Ok I have lost myself on file attachments.
Backstory - App is completed with serial numbers and issues,etc. When the tech changes status to Complete a bot generates an email with attachment. I have it set to archive but I am confused how I set it a specific archive folder and more importantly how I get the link back into an app column so you could open it from the app.
Have you checked this article already? https://support.google.com/appsheet/answer/11568421?hl=en&sjid=7511641170267109895-EU
Ok @AleksiAlkio I see most of the problem, I want to name my file “[customer] on [date]” but when it saves the file it saves the date as 20230503 and when it adds the file name to Appsheet column it is using 05/03/2023.
Ok I changed to using a key column and I got the Column set action to set the column, but I get this when I click on the link. I have verified that is the correct file name.
‘/appsheet/data/PDFTest/Service Calls/Test 5 Key - DKXbuR5sZmL74py26YobMQ.pdf’ not found
Probable cause: N/A
Path: Root
Result: FAILURE
Message: N/A
When working with files like pdfs, images, drawings etc., the path needs to start from the folder where the data source is. Like if you are using GSheet, and it’s in Root > AppSheet > Data > AppName-1234567, the path for the PDF file needs to start from that folder. Now it doesn’t find it because the “appsheet” folder is not in that folder.