Let's say I have three tables A, B, and C. C...

(Sam Drost) #1

Let’s say I have three tables A, B, and C.

C has ref columns to A and B. I would like to have C populated with a row for each value of B whenever a row is added to A (as well as a ref to the newly created row in A). Is that possible?

(Marc Dillon) #2

Check out the Actions section under Behavior. It should allow you to create an action that will create a new row in table C every time a new row is added to A.

(Sam Drost) #3

Any where I can find some examples? I can’t get actions to work for me.

(Marc Dillon) #4

A google search for ‘appsheet actions’ should provide a decent list of examples. Here is one I just found appsheet.com - AppSheet : mobile apps from spreadsheets : Maintenance Overview - AppSheet AppSheet : mobile apps from spreadsheets : Maintenance Overview - AppSheet appsheet.com

(Sam Drost) #5

Thanks. It seems I should have been less specific in my Google search.

(Phillip Panfili) #6

@Sam_Drost Sam did you ever get this action to work?

I am running into a similar sitution.

(Sam Drost) #7

Unfortunately, I have not. I found out how to add rows in another table when a row is added in one table, but I haven’t figured out how to make the rows reference a third table.

(Phillip Panfili) #8

@Sam_Drost the same rows that we’re added in the first table?

You figured out how to add them to second table?

(Sam Drost) #9

This video was the closest I could find, but it only shows how to reference one table when you add rows, I need to reference two tables. youtube.com - Reference Actions Demo - AppSheet Office Hours Excerpt Reference Actions Demo - AppSheet Office Hours Excerpt