I have created in my App an automation BOT to create a File (.pdf) and save it into a folder in Google Drive.
The name of the files is set with a formula which is:
CONCATENATE(“IRCA.”,[IDProposal])
I use the default folder path of AppSheet.
So i created a new column in my Google Sheets named “File” and an “Open file” action to write the folder path in this column, which is:
CONCATENATE(“Files/”,“IRCA.”&[IDProposal],“.pdf”)
I can’t understand why it doesn’t work when i try to open the file.
I receive this error:
@Marc_Dillon , can you help me to make this more clear for me please?
I think I have the same issue as Giacomo.
I have a bot and it “should” create a XLSX if something changes in a table (I know is well made because if I press execute it creates the file or if check the monitor everything is running fine, BUT it doesn’t create the file by itself.
So, here is my app folders paths (I made some folders moves to have a better organization).
Inside the gdrive main folder I have these:
/appsheet
/appsheet/data
/appsheet/MyApp-randomnumber
/appsheet/MyApp-randomnumber/Content ( was created by appshet because the XLSX template)
/appsheet/MyApp-randomnumber/Files (was created by appshet when I manually execute the bot)
The issue is the bot doesn’t create the file itself, it just work if I force the creation pressing the “EXECUTE” buttom on the test section in automation.
I was reading this topic and think what you suggested to Giacomo could help me.
The issue is the bot doesn’t create the file itself, it just work if I force the creation pressing the “EXECUTE” buttom on the test section in automation.
Is your app deployed? Do you have any conditions on the Bot?
Tovarsho:
I was reading this topic and think what you suggested to Giacomo could help me.
Which suggestion exactly? Your issue is quite different from the OP’s.
Is not deployed, needs to be? because (why it works if I force the execution?)
No conditions, just if table has adds or updates.
About the suggestion, Im talking about this:
Giacomo_Ria:> > > The spreadsheet is archived in an other folder in My Drive which is not the same of the “Files” folder (standard of AppSheet).> > I think that’s your problem then.
Could be a reason that doesn’t work automatically because I made some moves on the folders before?
Maybe the table that has the “ADD” or “UPDATES” events should be inside another specific path or something like that?
Could be a reason that doesn’t work automatically because I made some moves on the folders before?> > Maybe the table that has the “ADD” or “UPDATES” events should be inside another specific path or something like that?
I think you’re completely off-track. This folder is obviously where the files are being created, there is no folder difference between automated and manual execution.
Tovarsho:
/appsheet/MyApp-randomnumber/Files
Check the Audit History for detailed info of the data change and the subsequent running or erroring of your Bot.
Steve, I was reading around the community, and I think its a problem with something called “Large payload” because in the test menu, that’s appears for me.
Because Im just trying to make a copy of a whole file. If someone can help me, I will really appreciate.
