Hi all,
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:
Thank you in advance for helping me.
Solved! Go to Solution.
Did you disable the timestamp on the filename in your Bot?
Yes, of course.
It is not active.
File name in Google Drive is correct and there is not timestamp added.
Do you have anything set here for your file column?
Is the spreadsheet containing the Table in the folder that also contains the โFilesโ folder?
Hi,
No i didnโt write anything in the column โFileโ
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.
Can confirm that it was the problem!
I move now the sheets in the right path folder and it works.
Thank you.
Question resolved!
@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)
/myappnamefolder
/myappnamefolder/appsheet
/myappnamefolder/appsheet/data
/myappnamefolder/appsheet/data/MyApp-randomnumber
/myappnamefolder/appsheet/data/MyApp-randomnumber/recoverydata
PD: When I manually force the bot to execute, it creates the file fine in this folder:
/appsheet/MyApp-randomnumber/Files
Thanks in advance.
So what is the issue? What is your question?
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.
Is your app deployed? Do you have any conditions on the Bot?
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:
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?
Possibly
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.
Check the Audit History for detailed info of the data change and the subsequent running or erroring of your Bot.
I did it, and noticed something is wrong, my creation file task doesnโt appear there even when I execute manually.
There are no records from that task, jesus christ how can be possible.
I give up, donโt know why it doesnโt work if are everything well configurated.
@Dan_Bahir and @Zhifeng_Lin, can either of you assist here?
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.
Thanks.
Hi @Tovarsho
could you please contact our support team (Login - AppSheet) and we will look into your app with proper permission.
Thanks!
Yes, of course, thanks for your support.
I just let here a proof of what Im talking about.
About this problem, the support team reply that is needed to deploy the APP to use this feature.
Something weird is that others bot that I have works fine without deploying, but maybe is like that.
Thanks @Zhifeng_Lin and @Steve for your quickly response and help.
Best.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |