Can a form write to two different tables?

AppSheet AppSheet Q&A
,
1

I have an app that includes about 10 different forms for individual types of inspections.

Lets say the first 5 questions are common (who what where) among all forms and the last 5 questions are specific to which form it is. When I want to generate a report I have to query all 10 tables in google but all I am really pulling out of it is the first 5 (common questions) from each, the other 5 are only accessed when needed.

So my question is can a form write the first 5 questions to a common table and the last 5 to their own specific tables?

2

Depending on how your app is configured, you could evaluate using a LINKTOVIEW() action to navigate to second set of 5 questions when the first set of common 5 questions hav ebeen answered. The LONKTOVIEW() to the second set of questions form can be a form save event action on the first set of common questions.

Suvrutt_Gurjar_0-1655700535394.png
Suvrutt_Gurjar_0-1655700535394.png1317Ă—575 50.3 KB

https://support.google.com/appsheet/answer/10108214?hl=en

https://support.google.com/appsheet/answer/10106757?hl=en

1 Like
3

Thanks for the assistance, interesting idea, but I don’t think that will work since one of the common columns is “PASS / FAIL” which is based on the result of the other questions. Thanks so much anyways, gave me ideas for future.

1 Like