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 |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |