Data: add a new row to another table using values from this row - only the Task id info is moving over

Hi All!

Boss made ANOTHER change. Now he wants a master table (pre production) that only he can edit with pertinent data and then push the info as read only to the production tables. I used Data: add a new row to another table using values from this row and can only get it to fill in one of the 20 items from the row. Nor does the row appear in the google sheet as a new row in production. Any help would be great.

Thanks

If the tables are the same, and only the permissions are different, then you should consider using a Slice instead of a separate table.
https://help.appsheet.com/en/articles/895302-slices-the-essentials

2 Likes

I had it as slices but he wants to be able to lock the data. and he wants a whole separate table.

I figured out how to manually send it with the action button but I still cant make the data read only in the other slices.

In the Slice definition, scroll down to the Update Mode. You can individually set each Slice as Read-Only.

I would still recommend a Slice if the table structures are the same and the only difference is in the permissions.

Set your editable slice to have a row filter based on some column being blank:
ISBLANK([ColumnName])

and the Read-Only Slice with the opposite condition:
ISNOTBLANK([ColumnName])

This will ‘move’ the row form the editable slice to the read-only slice, without having to make two tables.

5 Likes