Hi,
I would like add a list into the menu. And the list is able to list down the available PDF in a folder in google drive and I can able to select multiple PDF to user defined email address.
I wonder if appsheet is able to do this.
HI
I don’t think you can build such a list into the menu.
Nonetheless, you can provide a view with a table list, with column type “url”, and use a script to set the url on the sheets : these url point to the Drive location for your pdf files.
That may be a part of the solution.
Here is what I made for a different purpose:
Here is how it behaves:
Tell me if you need the script to update url links on the sheet : I cannot join it to the message but you can give me your email address.
Thanks Aurelien!
There is no need for the script, I only got a few PDF that I wanna show. I had manually updated the link to the table. Appreciate your help.
I had add another view for that particular table.
However, I realized I can only send or share the pdf one by one. Is there any ways to make multiple selection and send to a single email?
I made that on another app, but without using URL.
I stored the PDF in a subfolder in my appsheet folder, and made the app point toward these.
Here is how I processed, if that can help:
Here is the example of my use:
the sheets/table related to the Button_send_files view, let’s name it “Button_send_file_table” :
==> the column B is for firing action with a workflow
The view “Liste DT”, based on a table “LISTE DT”
This is based on a simple table: the goal in my case was to determine if, yes or no, i want to send this file, for each employee (you can replace these with your pdf unique ID…here, “barcode employe” is my key-column for my table Employe)
Keep in mind that on my employees table, the column [File Id Card] is of “File” type.
The data stored there is actually a file pointing toward my Appsheet subfolder, such as:
appsheet/data/logistique_v0-1021166/Employes_Files/John SMITH/001. CNI DM.pdf
then, you need to explain which document will be sent. On table “Button_send_file_table”, I used a virtual column “attachmentList”, type “List”, with this formula:
SELECT(ENVOI_DT[file_CIN RECTO],
AND(
ISNOTBLANK([file_CIN RECTO]),
[Carte identité RECTO]
)
,true)
+
SELECT(ENVOI_DT[file_CIN VERSO],
AND(
ISNOTBLANK([file_CIN VERSO]),
[Carte identité VERSO]
)
,true)
Eventually (almost there!) set 3 actions : “switch_on” action that sets the “EnvoiDT” value (column B) to 1, “switch_off” action that sets it to 0, and another one “send” that’s a grouped action, with switch on then switch off.
Last step : workflow based on “Button_send_file_table”, update only, with condition:
AND(
[EnvoiDT]>0;
[_THISROW_BEFORE].[EnvoiDT]<>[_THISROW_AFTER].[EnvoiDT])
and action : send emailn with Other Attachement (you’ll find it down, down, down…) you set :
[attachmentList]
I hope I explained clearly, let me know if it’s not !
Cheers
Aurelien
Not possible in the main menu.
Correct!
Good idea!
It’s technically possible, but it’s very complicated.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |