Bonehead-proof user content input

  • 1
  • Question
  • Updated 3 years ago
  • Answered
I'm probably missing it, but I can't seem to find what I need in a simple widget. I want my users to have a dead simple interface where they enter text -no formatting font, color size or background -just text, and then have the text they enter go to a placeholder that I set up to display in the font, size and color I specify.

If I let users choose all that stuff they'll mess it up in no time -or worse, decide that they are just as talented as graphic designers and the presentations fill with goofy fonts and shockingly offensive colors. This thread from long ago is kinda asking the same thing: https://community.risevision.com/rise_vision_inc/topics/automated_input

What would be perfect is something with "Enter text here" and "Save". Bonus points for a way to add an image that would then scale to a predetermined size by how I specify it in the placeholder. Even more bonus points if they don't even have to open the Presentation and placeholder to do it.

The only way I've found to get close is to use a Wordpress blog and then feed RSS to the RSS widget in Risevision. This works OK, but it's clunky if I have multiple users and placeholders. 
Photo of George Greene

George Greene

  • 210 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Jim Coyle

Jim Coyle, Champion

  • 1,494 Points 1k badge 2x thumb
Hi George - I stumbled on your post when looking for something else but thought I'd reply seeing as no one else has :)

You have probably figured out something by now but if not then why not use a spreadsheet widget?

Your users simply enter text in a predetermined range of cells and you pull off that data and format as required in a place holder. Would work fine for text and your users don't go near the presentation at all.

You can also insert images into a cell and size them as required however I couldn't get them to display in the place holder. Perhaps someone in Rise can confirm if  this embedded image option is available in the spreadsheet widget?

Hope this helps
Jim Coyle.
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Thanks for answering this Jim,I'm not quite sure how it got missed.

George, another option for images would be the Image Folder Widget. Someone would have to set up that Image Widget in a Presentation to point to a specific folder, but after that it is simply a matter of that user logging into Storage, going to that folder, and uploading new images or removing older ones. They never need to log into the Rise Vision Editor itself.

If it is text, and you want to make it SUPER easy, Jim's spreadsheet idea above makes sense. That way the users don't need to log into the platform, they only need to update a spreadsheet.

Thanks!
Photo of Jim Coyle

Jim Coyle, Champion

  • 1,494 Points 1k badge 2x thumb
Hi Robb and thanks for this.

Regarding the embedded images in a google sheet. I can put an image into a cell and size it as required however this information doe snot seem to be passed over via the widget.

Is this the normal behaviour as I can see a useful purpose for embedding an image to the sheet.

regards,
Jim Coyle
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Jim,

Just so I understand, you want to be able to put a link to an image file in a Spreadsheet, and have it display that image in the Presentation running the Spreadsheet Widget, right?
Photo of Jim Coyle

Jim Coyle, Champion

  • 1,494 Points 1k badge 2x thumb
Hi Robb,

With google sheets you can embed an image into a cell and specify a width and height. See this hep page for details - https://support.google.com/docs/answer/97447?hl=en 
and https://support.google.com/docs/answer/3093333?hl=en

Usage:
To add an image inside of a cell, you can use the following formulas to change the size of the image in the cell. You must have a URL for the image you're adding.
  • Size to fit: Type <i>=IMAGE("URL")</i> or <i>=IMAGE("URL", 1)</i> into the cell with the URL of the image you want to add. Using this formula will scale the image to fit inside of the selected cell. If the cell is bigger than the image you're inserting, the remainder of the cell will be white.
  • Stretch to fit: Type <i>=IMAGE("URL", 2)</i> into the cell with the URL of the image you want to add.Using this formula will stretch the image to fit inside of the selected cell. The aspect ratio (height vs. width) of the image won't be preserved.
  • Original size: Type <i>=IMAGE("URL", 3)</i> into the cell with the URL of the image you want to add. Using this formula will add the image into the cell at its original size. If the image is bigger than the cell, some of the image may be cut off.
  • Custom size: Type <i>=IMAGE("URL", 4, height, width)</i> into the cell with the URL of the image you want to add, as well as your custom height and width (in pixels). Using this formula will add the image into the cell with your custom size.
Using this it would be possible to link the url of an image stored somewhere and have it display as part of the sheet data.

I can't get this to work and the url is simply ignored by the widget and no data is passed over.

I don't have a use for this at the moment but in the context of George's question it would have been usable

regards,
Jim Coyle
Photo of Jim Coyle

Jim Coyle, Champion

  • 1,494 Points 1k badge 2x thumb
Hi Robb,

I am misleading myself and anyone else reading this :)

The above google help is to display in the cell but won't send the required html to the widget - doh!

Just playing with this and applied some basic html which works.

If you use
<img src="https://www.google.com/images/srpr/logo3w.png" height="50" width="100"> this will display the Google logo via the widget on a display

To make this work you can format  a range of cells with various elements of this link and then build a single 'phrase' to be sent to the widget.

For example:

Cell A1 contains =CONCATENATE(Cell B1,CellC1,CellD1,CellE1,CellF1,CellG1,CellH1)

B1 contains the phrase <img src="
C1 contains the url reference https://www.google.com/images/srpr/logo3w.png
D1 contains " height="
E1 contains the height value of 50
F1 contains " width="
G1 contains the width value of 100
H1 contains ">

Thus you build up the phrase to be sent to the widget and the user only changes the url reference and the height and width values.

I am using this style to format text in other presentations out with the limits of the widget formatting. This way each row of data or individual cells can have its own formatting 'rules'

George - if you are reading this I apologise for hijacking your conversation :)

regards,
Jim Coyle
(Edited)