I'm super new to AppSheet so I really appreciate being able to ask questions here. (I give back in the Looker Studio forum, if anyone needs help there!) Simplifying my use case here and hopefully I'm using the right terms and things so my question is clear.
I have a Products table, and also an Expenses table. I want to have one (and only one) record in the Expenses table for each Product. But the Expenses table only has records for a few Products so far. I have set Product as a Ref field in the Expenses table and it is also the Primary Key in both tables.
I created an action on the Product view that links to the filtered Expense view for the given Product, and in that view Quick Edit is turned on so I can edit the necessary Expense fields. It's something like this:
LINKTOFILTEREDVIEW("Expenses_Detail",[_thisrow].[Product]=[Product])
The action works great to take me to the editable Expense view when the Product already has an Expense record, but if it doesn't, it just takes me to a blank screen. How can I get the functionality to see/edit the Expense record if it exists, or create the Expense record for that Product if it doesn't?
I don't think I want to link to the Form view because there are calculated fields in the Expense record that I need to see, and it looks like Forms only show editable fields? So Quick edit in the Detail view seemed to make sense.
Am I at least on the right track? Questions or ideas welcome.
Laura
LinkedIn
Twitter
