Actions to create and fill in a related record

AppSheet AppSheet Q&A
1

I have a table of elements and a table of inspections. If the item has everything OK, I want to do it quickly. What actions do I need?
Table of inspections:

  • Action 1: Create row
  • Action 2: update the id value of the element table
  • Action 3: update the OK value in field 1
  • Action 4: update the OK value in field 2
  • Action 5: action 1 + 2+ 3+ 4

Table of elements:

  • How do I configure the use of action5 if there is no row?

Thank you

2

Check out this article on LINKTOFORM(), it will allow you to create a new record and set values to what you wish.

3

Ok, thank you.
But LINKTOFORM opens the form with the uploaded data and I don’t want to open the form. I just want to enter the data. Can you configure it so that it does not open the form and only enter the data?

4

Using Auto Save to bypass Form View Questions

The builtin action to add a row to a table (without bringing up a form UI) is coming this week.

Seems this is a very in-demand thing all of the sudden.

5

Yes, of course… I already had it as action 1 but then I don’t know how to enter the data to the new record because I know how to point to the new record. If it worked as LINKTOVIEW and you could pass data to the new record directly it would be perfect.
Let’s see if there’s anything else we can do to get that.

6

did it happen? I am looking for it

7

2X_3_3e0eb8d910ce0763d8f8170f6802219f743bf9cf.png
2X_3_3e0eb8d910ce0763d8f8170f6802219f743bf9cf.png600×268 18.9 KB

8

Hi Steve

I am having trouble using “Add a new row to another table using values from this row.”

I want to be able to create a new record in table2 when a record in table1 is created.

I have created a workflow event from the but the saving of the record in table1 does not trigger the creation of the new record in table2.

How do I trouble shoot what is going on? I don’t see any errors.

Regards
Steven

9

Please post a screenshot (or shots) of the entire workflow configuration.