Forms - Remove option after completing

[Kayleigh_Seeley]

Hi,
I have an app where my students will log patient encounters. I have had many of them ask if it is possible to have an option on the form be grayed out or removed from the list once they have completed or “logged”. I am not well versed in AppSheets so I am reaching out to see if it is possible to have a task removed from the list once it is completed?

Thanks!

[WillowMobileSys]

Yes, this is very doable. There is a “Show_If” property on the FORM view that you can use to conditionally show or hide that Form. You cannot base it on row info but you can use SELECT() statement. I explain below

How you implement this is predicated on the ability to identify that a particular student has indeed completed the form. You will need to be sure that when the form record is saved that you are also saving info to identify the student. How you do this will be based on the AppSheet plan and capabilities available in that plan.

For example, If your app requires login, then you are all set. You simply need to save the USEREMAIL() value with the form record - say in a column named “Student” in “Patient Encounters” table. Then in the Show_If field of the form, use an expression like “IN(USEREMAIL(), SELECT(Patient Encounter[Student], TRUE)”.

If you app does NOT require login, it can still be accomplished but requires some additional implementation to be able to identify the student.

[Kayleigh_Seeley]

So I do not fully follow and maybe that has to do with how my app is setup I could not get the “Show_If” formula to work.

All of my component apps are setup from a google form that I then made the apps from.
Below is what the form section of the app looks like:

And this is a sample of the spreadsheet for the app form:

How would I go about having a “Patient Interaction” option removed from the list of options once logging? Is it possible with how the app is currently setup or would it require setting the app up differently?
Thank you for your help!

[Fabian_Weller]

Hi @Kayleigh_Seeley I think what you want is something like:
In the [Patient Interaction] you have for example

• Option 1
• Option 2
• Option 3

When you once selected Option 1 and save it, next time you open the form, you don’t want Option 1 to appear, but only:

• Option 2
• Option 3

If this is what you want: It’s possible And I don’t think you need to change the Setting of your App.

What you have to say in the Setting of the column [Patient Interaction] is:
“Give me all the Options and subtract the ones already selected.”

Please take a look on my Sample App “Orders”.
https://www.appsheet.com/portfolio/549987

[Kayleigh_Seeley]

Hi,

Yes! That is what I am looking for. Right now the students have the long list of items to choose from and they are hoping that once they select an “Patient Interaction” it would remove it as an option to chose from.

I took a look at your app and I am not sure where in my app I would need to put the “Give me all the patient interactions and subtract the ones already selected”. My patient Interactions column is an “Enum” type so the students are able to select from the list of options.

Thanks!

[Fabian_Weller]

Sorry I forgot to mention. Please look in the expression of the suggested values. Here you put all your values.

[Kayleigh_Seeley]

Where is the expression of the suggested values at?

[Fabian_Weller]