Solved: How to save a name instead of the ID - Page 2

gymbuddy · 09-22-2022 08:47 AM

Hi,

I have 2 tables. order details and premix.

When adding a new order in the order details table, I select the premix from a drop down (ref from premix table),

When the record is saved in the order details table, I notice it saved the premix ID instead of the premix name.

one of the solution is using virtual table, but I don't know the formula, what I want to set in app formula.

Thank you in advance

SmartsheetGuru

@gymbuddy What is the purpose of saving the name as well, are you wanting to access the raw sheet and look at the data that way? Else, if you are using Appsheet to look at the data or creating reports from the data in Appsheet, the ID is all you need since you can use the dereference expressions to get any other columns in the table referenced by the ID.

If you really want to save the name in the table, you could create a column and set it to [premix][premix name column]

View solution in original post