Does anyone know if it is possible to create ...

references
(Bituminous Roadways) #1

Does anyone know if it is possible to create a copy action that not only copies the selected row, but also copies any rows from another table that reference the selected row and change their reference to the newly copied row?

Example Table 1: Key

Data 1

data1

<-----copy this row

Table 2: key

ref

data a

1

data1

<-----also copy these rows b

1

data2

<-----also copy these rows c

1

data3

<-----also copy these rows

Table 1: Key

Data 1

data1 2

data1

<----new row

Table 2: key

ref

data a

1

data1

b

1

data2

c

1

data3

d

2

data1

<-----new rows e

2

data2

<-----new rows f

2

data3

<-----new rows

(Aleksi Alkio) #2

I’m afraid that’s not possible yet. Please vote this feature from here… www.appsheet.com/feature-requests.

(Bituminous Roadways) #3

I was hoping you would chime in, but with a brilliant idea using the API or some new feature that I missed…oh well.

(Aleksi Alkio) #4

Of course you can do that with a Webhook and API call or scripting, but it will be much easier to do that directly from the app.