Appsheet from form recreate spreadsheet problem

[amunizp]

So really excited to discover that I can use the branching from forms: https://help.appsheet.com/en/articles/961635-multi-page-forms-with-conditional-branching

I created a basic app and saw that it worked fine. 

I later started adding more questions and more branches and requiring sign in from the user. 

But when I click the prepare button it asks me to reload the sheet, which I do. But It still comes  back to the same problem.

This keeps popping up!

I tried un linking, and rewriting and creating a new sheet. Same problem every time. 

At first I thought it was because the questions had the same name, but I went through all the questions to make sure that they were written differently:

Timestamp

Email Address

Where are you?

Page 2 Header

Page 2 Description

Please paint us a word picture!

Please give us a description to help us find out how to sort it.

In Everyone' s Kitchen, what type of check?

Everyone' s Kitchen Safety, what Frequency tasks do you want to do?

Everyone' s Kitchen Cleaning: What Frequency tasks do you want to do?

Everyone's Kitchen Maintenance What Frequency tasks do you want to do?

Everyone' s Kitchen Safety Monthly Which Task have you completed?

Everyone' s Kitchen Safety Weekly Which Task have you completed?

Everyone' s Kitchen Safety Daily: Which Task have you completed?

Everyone' s Kitchen Maintenance Daily: Which Task have you completed?

Everyone' s Kitchen Maintenance Weekly: Which Task have you completed?

Everyone' s Kitchen Maintenance Monthly: Which task have you completed?

Monthly Everyone' s Kitchen Cleaning tasks: Which of the following did you complete?

Weekly Everyone' s Kitchen Cleaning tasks: Which of the following did you complete?

Daily Everyone' s Kitchen Cleaning tasks: Which of the following did you complete?

What am I doing wrong?

[Marc_Dillon · Accepted solution]

Best thing to do it to start completely from scratch.

Building an Appsheet app from the GForms add-on is like wading through mud. If you don't actually need a GForm, I highly suggest taking some time to learn the Appsheet platform a bit more and just creating your app from a GSheet and skipping the GForm add-on stuff. Well, even if you do need to use GForm, take some time to learn more about Appsheet first...

https://help.appsheet.com/en/

[amunizp]

Thanks! could not find a way (or an efficient way) to do branched forms. The only way I got to do that was by doing an if clause and asking to hide the questions not needed. 

but that is not a feasible way of doing it because I end up with loads of columns each with having to click twice to be able to edit the if clause. and I have 100s of questions. 

[Marc_Dillon]

You have to use "Show" type columns, with "Page Header" subtype. Then you can hide or show entire pages worth of columns based on the values from previous columns. This is exactly what the GForm add-on sets up for you.

https://help.appsheet.com/en/articles/1013271-column-types-diving-deeper

https://help.appsheet.com/en/articles/961221-show_if-column-constraint

[amunizp]

OK could not get the header thing going but using the filter in the show part I put this on:

and(if([Check In].[Key]="CI Cleaning", True, False),if([Check Out Log Entry Category].[Key]="5. Monthly", True, False))

You are saying that the Header part hides several in one go? So if I have 3 columns I only need to put the show condition on the header and not on each column?

[Marc_Dillon]

Yes, that is basically what I said.

[amunizp]

Hi Marc,

Screen shot of current settings

Thank you. So I have tried it as attached. Form questions as show or as no show. The section_header does not seem to come up and if it does come up, putting questions as Content does not seem to influence if they show or if they don't. 

The videos here seem to be from an older version of appsheet. and do not seem to offer the option of hiding columns. 

I now realise what I am trying to do might have been attempted and not working the way I intend it to work? https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Section-Header-Show-If-not-applying-on-followin...