When doing a check add row to another table with parts of this check

[Joel_Tjon-A-Tsi]

Hi Appsheet community,

I have created a form for the Technical Guys to do there inspection. Each form starts with “Location” and “room”. The location is automatically filled (depending who is logged-in), he or she can then select a room.

The form holds about 50 Questions. The question field look like this:

Column
“Room_Q1” - Looks to the “user name_Location” and then selects the first question of that location.
“Room_A1” - Is an answer “Checked”, “Fixed”, “Problem”
“Room_P1” - If “Room_A1” is “Problem” take picture
“Room_C1” - If “Room_A1” is “Problem” leave comment.

This repeats 50 times.

We have a Table in the sql database where all “problems” are stored. This Table is synced with a ticketsystem in salesforce. What we want to create is a form in Appsheet and sync only the problem issues as a problem in the problem table, which is then synced with salesforce.

(and in case you are wondering, why not load the salesforce table directly into your app,…We build the application on a sql database because of the sync time)

So,…to the solution,…(all most then)…

I want to create a action: Create problem in problem table: where i set the action to:

Now,… i think i need to do this for each Question separately, creat a new action i mean. Am i on the right path? Or missing some thing?

Or,… is there an easier way?

gr Joel,