If false use user input expression help

AppSheet AppSheet Q&A
1

Hello,

I have an initial question of : Is houskeeping relevant to your inspection? yes/no

If True, the next set of questions appear each with an enum of Pass, fail, N/A, Not observed. - This is my show if

Next step was trying to autofill - this a am using in the app formula for the related question(s)

if [houskeeping relevant] is false, it is set to return N/A Automatically for all related questions. - This works fine.

if [houskeeping relevant] is True, I would like the original enum of Pass, fail, N/A, Not observed to appear.

This is failing to happen. What appears is “pass” and it is uneditable.

How do i write this to say if true , Show the original question

an example of how i have tried to write it using one relevant column:

IF([Housekeeping_Relevant] = False,“N/A”,[Heating Equipment])

2

I’m not confident that I follow what you’re trying to accomplish. Based on my interpretation, the following approach might work for what you need.

In each column:

  • Editable property: [Housekeeping relevant]
  • Initial value property: IFS(NOT({Housekeeping relevant]), “N/A”)
  • (Optional) Show property: [Housekeeping relevant]
3

Make an IFS() where you cover both situations.

IFS(
 NOT([hou....]), "N/A",
 [hou....], ""
)
1 Like
4

Initial value of IFS(NOT([Housekeeping_relevant]), “N/A”) worked.

When i selected yes the next question appeared where i could make my selection, when no was selected nothing appeared. When i saved and checked the sheet, it DID update an N/A for that field.

It didn’t show while filling out my form because it was following my show if parameters of dont show the question at all if [Housekeeping_relevant] was false (Duh)

Thank you

5

So i attempted this for a situation a little bit different. I must be doing something wrong.

Question 1 [Passing]- Mark all question as passing? yes or no

Questions 2 -5 - i wrote out the scenarios for passing if true, blank and false.

if true = “pass”

If false , use the original question (this i am probably doing wrong)

Results - Questions 2 -5 do not appear.

Question 1 [passing] is set to true , questions 2-5 appear with “pass” as the selection- good

Question 1 [passing] is set to False , questions 2-5 do not appear - Why?

Question 2-5 are enum based with answers pass, fail, N/A and not Observed.

I would like to do this with a formula and not an action.

6

If for questions 2-5 the Show or probably even Editable properties are set to the value of Question 1 [Passing] or the app formula has an expression, then they probably won’t appear in the form. As long as Show isn’t false, they can appear in non-editable views.

1 Like
7

I wanted to come back to this and share my experience. Different situation, similar results.
I have an initial Value of
IF([FPS_Present_Serviced] = True,“”,
IF([FPS_Present_Serviced] = False,“N/A”,“”))

This Works Fine. True, opens up a list of enum choices and false saves the N/A.

Now, If I select true and select N/A , I have data validity error saying i cannot do that. This is also good.
I also Have a validity error set to say If a select False and selection <> N/A , Then false.
Situation:
If I select True and select a column choice other than N/A (which is fine), and then decide i change my mind to [FPS_Present_Serviced] = False but i do not clear the choice i selected, it keeps the choice even though my selection is false.
No error is generated.

Question:
If i Select a choice, then change my mind to say [FPS_Present_Serviced] = False, and forget to change my choice to N/A,how do i set the value to clear or reset to default N/A?

Additioanlly,

When that situation is saved the display within the details is correct, FPS = No and nothing is shown for my messed up choice However, in google sheets, my selection is shown