I use an Integromat Webhook to send data to 3 columns. Working fine.
In the AppSheet App I have an Action that sets 2 other columns: A Yes/No column and a DateTime column. Also working fine.
Now when the Webhook sends data to the 3 columns and the user hits the Action to fill the other 2 columns, AppSheet will override the 3 columns.
Why: The App has not yet fetched the 3 columns that Integromat sent to AppSheet via Webhook. So for the App these 3 columns are still blank. That why it clears them out.
How can I tell the Action: Donโt touch these 3 columns?
I tried Editable? CONTEXT("Host")="Server" but this does not help.
I found that I could solve it via a Form based on a slice. This slice does not include those 3 columns. By saving the form, the 3 columns will not be touched.
But I donโt want to use a Form. I want to use an Action.
LinkedIn
Twitter
