I need to save the URL of a file saved in google drive automatically, I created the following:
Create a Workflow rule to create and save the file, inside body information i used <<_ATTACHMENTFILE_URL>> variable and it is working very well
I create an action to save information in a file into a table, i used the http information as result of <<_ATTACHMENTFILE_URL>>, in this case I used concatenated formula to decoding every part of the url. I can decode part of http information, as following:
CONCATENATE(
โhttps://www.appsheet.com/template/getappfileurl?appName=Violeta-1900059&fileName=โ,
ENCODEURL(โComprobante Aportaciรณn - Folio: โ),
[Folio Ingresos],
ENCODEURL(โ - Nombre: โ),
[Nombre],
ENCODEURL(โ - Copia: โ),
[Actualizar],
ENCODEURL(โ.pdf&appVersion=โ),
[1.001693],
โ&signature=โ,
[5a5fcfc6ce6fe8d4b0dffd0c3dc69d6b9e455a434e5ee71badfcd98f1221492860de85cbbbb03c93f80c82d8dbc5035f])
However i donยดt know identify:
Version of my application, because this will be dinamic, in this case 1.001693
signature: this is a dinamic information, in this case is โ5a5fcfc6ce6fe8d4b0dffd0c3dc69d6b9e455a434e5ee71badfcd98f1221492860de85cbbbb03c93f80c82d8dbc5035fโ
I was reviewing https://help.appsheet.com/en/articles/2744751-email-attachment-file-archiving, but i did not find anything to identify the two points below
Thanks a regards
Solved! Go to Solution.
Hello I did it, I only create the URL until attachment name โ.pdfโ and it worked very well, was not necessary the Application version
Regards
I donโt understand what youโre asking of us.
I am asking two things:
how identify currently application version in order to put into concatenate formula something like [_appversion], because this is dinamic
How to identify the parรกmeter โ&signature=.
This is the original url that i have it for one file, but this URL must be calculated dinamically, the last part of the url I donโt know how will be created, its means what is the value for &signature=
https://www.appsheet.com/template/getappfileurl?appName=[APPNAME]&fileName=[ATTATCHMENT NAME].pdf&appVersion=[APPLICATION VERSION]&signature=[88a9d20703519e877580164f7be1d47b1788c06869f08e4972ba69ed4cea2cf29b17cda0ae5ee142ca4455d25d1f0c70]
From &signature i donโt know what it is
Regards
I reviewed and the last &signature it does not necesary, it is created automatically, only is necesary app version.
It is possible to introduce in the concatenate formula, the command to identify last application Version?
Regards
I am not aware of a way to get the current app version programatically.
Thanks a lot for your helpยกยกยก
Hello I did it, I only create the URL until attachment name โ.pdfโ and it worked very well, was not necessary the Application version
Regards
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |