Gallery view - possible to "disable" one image?

But obviously “closed” has another meaning as well or you probably wouldn’t have asked the question “how to trigger activation”?

My recommendation is to have a dedicated column for [Activated?]. Initially set to “N”, once activation has happened then set it to “Y”. You can also have the option to “de-activate” at any time, regardless of status or state.

Storage is cheap these days so having extra columns, even they don’t do much, is NOT a big deal.

Think of support as well as users usage of the app. If you ever need to be able to determine if “activation” actually happened or some other error occurred, you’ll have a column to tell you immediately.

If you try to use an already existing column that has another meaning (e.g. Status) then as soon as the state changes, you loose the information that “activation” happened or not.

Bottom line, I would suggest to never mix multiple meanings into a single column. It often creates headaches later.

I hope this makes sense!!

1 Like

That makes sense. What table should I add the activated column to?

I have a table for the menu/gallery, the evac center list table, and then the actual evacuation record table that collects all the form data.

And it doesn’t sound like this should be a virtual column. Is that accurate?

Okay so I’m taking it that you have a slice of “Activated Evac Centers” right?

What you need now is a way for the app to know where someone is at?

You said this way public based yes? So people are not logging in I take it.

We need a way to be able to tell the app (The current user is at “this” location) - then we can see if that location is activated or not.

Geofencing? Is that an option? Do you have geolocations for each evac center?

we aren’t using user location. and i don’t have a slice for activated evac centers - instead using data validity (SORT(SELECT(Gen Pop Evac Center List[EvacCenter], [Status]=”Open Accepting Evacuees”)) - which works well for what we’ve done so far.

I think I will try to add an “activated” field to the menu table and see what I can do with that.

So what exactly are you activating?

Your initial image showed “Form” at the same level as “Evac Centers”. Your comment was…

This made me think you are activating for the user. Is that not the case?

Never mind. I went back to re-read the comments to find this in response to how you know if something is activated or not.

I gather from this that you are activating centers. So I need to ask two different questions.

  1. What does active/activate mean? How does it differ from closed?

  2. I assume there are several Evac Centers. So, which one triggers the enabling of “Form”?

Were you able to remove if from the list in your attempts at this?

The form option I mean - were you able to remove that from the options shown already? Have you figured that part out?

no, sorry, county activation (opening evac centers).

How does one user from one county receive data different from a user in another county?

If I’m in County A - you’d want me to see Count A’s information. How is that happening in the app right now?

I’m not sure I understand your question. This has been created just for our county.

I added an “activated” column and changed the action from just [Item]=Form to AND([Item]=Form, [Activated]=Yes) and this prevents the form from opening.

How would I swap out the images though?

You could create an additional column that holds the greyed out image - then another that switches between the two depending on the status - and use that as the label for the table.

I think the reason for the “user in county” question is an attempt to understand how activation works.

I’ve been thinking about how this might work in your app and will venture a guess. Tell me how close I am!!

  1. A state of emergency is declared and the decision is made to use Evac Centers.
  2. You would “Activate” the Evac Centers in the app and this enables “Form”
  3. However, while there may be say 20 Evac Centers. Initially only 10 open and others stay closed until needed.
  4. A user opens the Form to fill out needed information, a part of which is selecting the appropriate open Evac Center.
  5. As Evac Centers become Full, others may open to take on overflow.
  6. As emergency needs decline and wind down, Centers return to a Closed state.
  7. Once all centers have closed, emergency is over, the app is “de-activated” and the Form becomes disabled.

So…how close was I???

Very close. Post Hurricane Irma the decision was made we open all for an incident instead of a tiered approached but you outlined it well.


I’ve never attempted a “switch” before. I’ll try it.

It doesn’t seem Smartsheet works well with 2 image attachments in the same row. I tried to add another column as mentioned but it essentially made the app unrunnable.

Here is where I’ve ended up. Clicking “no” or “pre reg form” doesn’t do anything but take users to home page. Would be nice to have a gray image but I may not be able to make that happen.

1 Like

I’ve never even heard of Smartsheet before joining this community, so I can’t help in that realm. But in Excel, I use relative image paths of “/Images/ImageName.png”. Doing that allows me to also do things like:
CONCATENATE("/Images/", [ColumnOfSomeSort],".png")

If you can also use relative pathways instead of direct attachments to the sheet, this may be easier than any other way.

1 Like

Do you store your images in the cloud in order to use them?

Yeah. I use an Excel sheet on OneDrive.

File Name Value

If you store the value as a file name, the image or document must be stored in your cloud file system, not on your own computer!

  • In the app editor, we provide a file selector widget that lets you browse your cloud file system to find an image.
  • If you are specifying an image or document file name in your spreadsheet, the file should be in the same folder location as your spreadsheet. For example, if you use Google Drive and your spreadsheet is in the /appsheet/data/MyApp folder, then if you have the image MyImage.jpg in the same folder, you can just use the value, MyImage.jpg , in the appropriate cell.
  • It is sometimes easier to organize images in their own folder. For that reason, we allow image file names to be specified relative to the location of the spreadsheet. For example, if your images are in a subfolder called Images , you can use the cell value, Images/MyImage.jpg or ./Images/MyImage.jpg .