Action/Expression Problem

AppSheet AppSheet Q&A
,
1

Good Afternoon All,

I’m going to Try to explain this as Clearly as possible as to not cause confusion,

I have 3 Tables.

Table A ~ Parent
Table B ~ Child of Table A.

Table C ~ Standalone.

The User Fills in Form A and Create a Few Childs (Table B).

What I’m looking to do is upon Form Save, Enter a New Row with Data for Each Child into Table C. Data would be based off of Table A and the corresponding Child the Row is being Added for.

User Fills in form (Parent Table A)
User Create 3 Childs within Form (Child Table B)
User Saves Form.

Upon Save I would Than Like to Add 3 Rows to Table C based on Data from Table A and the Corresponding Child.

The User could would also be able to add only 1 child, as well as 4 Childs. This is the unknown variable Im having trouble with. But this needs to Stay Variable.

Preferably not with a Counter in the spreadsheet for looping, I seen a post somewhere about forms advancing Automatically bla bla bla but cant find this anymore anywhere.

1 Like
2

Can the user add children after the initial save of the parent? If so, how would you see that being handled?

3

Action 1

  • For records of this table: Table B
  • Do this: Data: add a new row to another table using values from this row
  • Table to add to: Table C
  • Set these columns: (as desired)
  • Only if this condition is true: TRUE (or blank)

Action 2

  • For records of this table: Table A
  • Do this: Data: execute an action on a set of rows
  • Referenced Table: Table B
  • Referenced Rows: [Related Table Bs]
  • Referenced Action: (action 1)
  • Only if this condition is true: ISNOTBLANK([Related Table Bs])

Set the Form Saved event action to action 2.

3 Likes
4

No they Cannot

5

Let me Try this, I have something else that just came up so I will get back to you but not right away

1 Like
6

Steve, Thanks You, this worked perfectly on the first iteration.

3 Likes