I have a general question about the best way to cater for branching logic. Here is a simple hypothetical example that seeks to make a conclusion whether someone is a resident for immigration purposes. Some of the questions (white rectangles) can be answered by a user in a Google Form feeding a Google Sheet and in turn AppSheet. Other questions are answered by a calculation (hexagon) based on the answers previously supplied by the user.
I thought I could use a virtual column in AppSheet including the calculation to come to the conclusion whether visa days is less than 100 days or otherwise. The relevant Residency conclusion is then compiled into a Report emailed to the user. Is there a better way to deal with branching decision structures leading to different report conclusions? Especially when there is a complex branching structure.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |