Edit data on referenced tables

AppSheet AppSheet Q&A
, , ,
1

App tables: EventData, Locations

eventData has a column named Location which is a REF to ‘Locations’. Added a virtual column named ‘Info’, with a formula of: [Locations].[Info].

When viewing/editing an eventData entry, the ‘INFO’ field from ‘Locations’ is shown with correct data from that linked table. However, that linked data is not editable. What is required to not only see, but when an edit occurs, it is made to the source: [locations].[Info]?

1 Like
2

Virtual columns are not editable.

If you want to change the column you have to do it directly in the locations table.

1 Like
3

I see… is there a way to make this work as desired via another path?

4

https://support.google.com/appsheet/answer/11621688?sjid=13592728809833006806-AP

Use this to update info using INPUT function.

5

Thanks. Need to read up on this a bit more, but looks like a good solution!

https://www.youtube.com/watch?v=Ku1qqvB5CLI