Dear AppSheet team,
I have a questionaire app connected to AppSheets. This questionaire has different sections so I have split them into different tables. The entries in the questionaire main table have a reference to the sections. I only need a 1 to 1 relationship between the questionaires and sections, as once a section is completed it is only related to one questionaire entry.
When I manually create the links in google sheets and use the app it all works. I can see the sections listed and I can navigate to them. However when I create a new questionaire entry and open it I have to select the sections from the drop down list, or create a new section using the ‘New’ option in the dropdown list. These sections do not have particular names that can be identified easily in a dropdown list and I don’t want to use a dropdown anyway as I think this would be confusing to a user and would allow them to select other peoples answers.
The way I would like it to work is to have a single link e.g. Section 1, and when this is clicked, if an entry exists this entry is shown (which is the way it works now), however if an entry doesn’t exist the user is presented with the form for that section. Basically the 'New" option in the drop down list should be executed if an entry doesn’t exist but without having to select it from the dropdown box.
A formula like this is what I was thinking, but it is now allowed for a column of type ref: “IF([section_id]=’’, LINKTOVIEW(“Section1 Form”), [section_id])”
I have also tried adding an action button to present the form, which works in adding an entry to the sections table, but doesn’t update the questionaire table with the reference ID of the new section entry.
Any help is solving this would be much appreciated.