I’m having an unexpected situation here.
Previously I was able to make a button with Actions/Workflows, in order to create a file then access it with a file column, as explained by @Rich in this post:
Now I’m trying to re-create that with the automation feature, but as you can see : it writes down the correct value, then replace it with the previous value.
I checked: there is no “reset on edit” on the file column.
My bot is really simple:
- When event occurs “Quote TriggerQuote Switches” : UPDATES_ONLY
AND( [_THISROW_BEFORE].[TriggerQuote]<>[_THISROW_AFTER].[TriggerQuote], [_THISROW_AFTER].[TriggerQuote] )
Run process "Process_CreateQuote"
This one updates value on [QuoteFile] column (Set row values):
“appsheet\data\myFolder”&TEXT(NOW(),“YYYY_MM_DD - hh_MM_ss”) & “Quote” & [QuoteReference]& “.pdf”
This one creates the file, with FileName Prefix:
SUBSTITUTE( SUBSTITUTE([QuoteFile], "appsheet\data\myFolder\","" ), ".pdf","")
And that’s it !
The file is created, so that’s half the job done.
I don’t get why it’s coming back to previous value on the file column in the Quote table.
At investigating, I noticed the Bot Monitor shows:
The 4th step intrigues me, even if I don’t think this relates to my issue.
What is it ?
Edit : minor changes