Hi there
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:
[Get URL of workflow generated file](https://community.appsheet.com/t/get-url-of-workflow-generated-file/26607/2) Questions
Hi Jason, give this a try and let me know if it works. Add a file column to your table Make sure you use a formula to set the filename in the “Save File” workflow. Create an action (call it “set filepath”) that sets the value of the file column using the same formula as the “Save File” action. Add the “set filepath” action as an additional step in your workflow after the “save file” step Create another action called “open file” with a condition to only be visible when “filepath” is not blank. …
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]> )> >1. Run process “Process_CreateQuote”
a) create_quoteName_with_timestamp
This one updates value on [QuoteFile] column (Set row values):
“appsheet\data\myFolder”&TEXT(NOW(),“YYYY_MM_DD - hh_MM_ss”) & “Quote” & [QuoteReference]& “.pdf”
b) createQuoteWithName
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