I have an app that generates reports which are emailed and then saved to a Google Drive. I also use this Google Drive folder as source of files for a “Reports” table. On occasion a user may need to re-send the saved report. We can do this, without re-generating, by using the “Other Attachments” property and attach an already existing file.
However, I am having difficulty in AppSheet recognizing the File column from the “Reports” table. Also, any usage of Virtual Columns are blank when it gets to the “Other Attachments” step of the Bot
If I hard code the folder + filename all works as expected. If I create a “normal” TEXT column with the folder + filename assigned, it works.
But if I use a File type column or try using Virtual Columns (only way to add a column to the “Reports” table sourced from a Google folder) it doesn’t work.
It would be nice not to have to go through the extra effort to create columns that specify the correct path + filename text just so these files can be properly attached to an email.
Am I doing something wrong? Does anyone have any insight on how I can more easily get these existing files attached to emails?
Attempt to use File column - highlighted area Path not properly extracted
Open File works fine at retrieving the correct file. Automation should be able to do so also for attachment.
