Hi,
I had a table called Quote Configs. It had a quote config ID column, a quote ID column, and various other config columns.
I had an automation so when a new quote is created, it creates a new quote config. On the new row for quote config, the quote config id and quote id are both set to the same value as the quote ID on the original quote row.
This worked good, however there's another situation in my app where I want to have a project config table, however data in the project table is being imported via an api in a google app script, so I can't use Appsheet to create a new project config row same as I did earlier. (I could do it through app script, but what I did detailed next is much easier)
I came across computed keys and thought this would work great for what im doing. Previously when I first wanted to create the quote config table, before setting up the automation I half went down this route but didn't know about computed keys so I hit a roadblock.
where I am now: I have removed quote config id from the config table, and added a computer key which its formula is [Quote ID]. In google sheets I have the formula on the quote ID column cells is =Quotes!A2, so now for every quote thats in the quote table, there is automatically a quote config in the quote config table. The computed key is calculated from quote id.
Everything so far is great, in app sheet I can view the quote config and its good, all data there, looks good.
My issue is, now when I change data in the quote config form and hit save, wait about 5 seconds or so as usual for the badge on the refresh button to go away, and there has been no change in google sheets. it isn't changing anything. no errors.
Ive tried to change a bunch of things and experimented for a while now and haven't gotten anywhere, I can't get it to save and update the row in google sheets.
Im really not sure where to go from here or how to work out what's going on.
Any info would be great thanks!
LinkedIn
Twitter
