Action/Expression Problem

Jonathan_S
Participant V

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.

Solved Solved
1 5 193
1 ACCEPTED SOLUTION

Steve
Participant V

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.

View solution in original post

5 REPLIES 5

Steve
Participant V

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

No they Cannot

Steve
Participant V

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.

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

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

Top Labels in this Space