I have an app of a sign inventory, and sign repairs. I have a dropdown list of the sign numbers for the sign repairs as a ref column and it all works great. During testing I needed to edit a sign number in the sign inventory, and of course I couldn’t because it is a key in order to be referenced. I assume there is a work around with Lookup or Filter but I am not seeing a similar situation. It was a very automatic app creation from of Google Sheet. I am very inexperienced with App sheet. Thank you for suggestions.
You should not be changing key values regularly, if ever.
“I assume there is a work around”
No, not really.
If you absolutely need to change a key value, that is best done in the backend data. Note that you’ll also have to change the value in all records that reference the record that you’re changing. Though, if you do have this need, you more likely need to rethink your chosen key values. I personally recommend using UNIQUEID() “surrogate” keys for the vast majority of tables.
I think that you are not talking about edit [ID Column] (Or however you has named your Key Column)
So, if you what to edit any other column diferent to you key column from a view that not use their table as the main, you can add an action to edit the reference values.
- Add a new action: “Go to another view whitin this app”
In Target put the funtion: LINKTOFILTEREDVIEW(“Sign_Form”,[Sign_Number]=[_ThisRow].[Sign_Number])
It’s important that you don confuse this function with LINKTOFORM() Function, this one will add a new row, and the previus one will edit the existed row.
If for a random cause you select your [Sign_Number] as key column but you hava the need edit it constantly, you must to add or select a new colum as key colum almost always called [ID_“Name of your table”]