I've a table where it saves Fees paid to the ...

(Swapna Nirman Welfare Association) #1

I’ve a table where it saves Fees paid to the society from each resident. Once a new line is added, a workflow rule is triggered and then a PDF is sent to the email ID of that row. These PDF’s are all archived in google drive. I want to display these PDF’s within the app i.e., each row will display its respective PDF after generation. Is this possible?

I’ve watched this, which actually explains it in the end, but I didnt completely understand it. https://www.youtube.com/watch?v=xj0kE5btw50

Please note that the location of the actual google sheet that the app is based on and the attachment are not in same file path

File at: Drive Path/Maintenance/Sheet.xlsx Attachment: Drive Path/appsheet/data/[App Name-ID]/Attachements

(Aleksi Alkio) #2

Check this post… plus.google.com - Hi, I was wondering if there was a way to dynamically or automatically creat… Hi, I was wondering if there was a way to dynamically or automatically creat… plus.google.com

(Swapna Nirman Welfare Association) #3

@Aleksi_Alkio I’ve created an extra column to hold the URL and defined it as a ‘File’ type. I’ve gotten to the point where it is properly directing me towards the exact file. The only thing that is throwing me off is the time date stamp.

For example even though i named my attachment “Receipt”, in google drive its being saved as “Receipt20181015_103133_779”. Here i can concantenate the time date stamp using month, year, day, hour, minute and second. The last 3 digit random number is where i’m thrown off.

(Swapna Nirman Welfare Association) #4

On further research. I did find a template variable <<_ATTACHMENTFILE_URL>> which is actually giving me the exact URL for attachment. However I cannot use it to save that URL in spreadsheet as it can only be used in template for attachment. Please help

(Philip Garrett) #5

@Swapna_Nirman_Welfar

I am not aware of any way to capture the attachment file name and store it in a column.

(Swapna Nirman Welfare Association) #6

@Philip_Garrett_Appsh

Hi Philip. At the moment, I put the <<_ATTACHMENTFILE_URL>> in the body of email being sent and then manually updating the receipt (url type) column after getting the link from mail. Is there anywy to automate this?

(Philip Garrett) #7

@Swapna_Nirman_Welfar

Sorry, I am not aware of a way to automate this.

You might explore whether you could use an email to trigger Zapier and then use the AppSheet API to update an AppSheet table. I don’t know enough about Zapier to know if this is actually possible. I cannot provide any details on how you might do this. I am not sure it is even possible.