Is there a way to capture and store in a column the file name of PDF or Image, automatically generated by Appsheet when you upload or save through form or workflow?
I know that Appsheet adds the date and time as uniID to the file added or uploaded through a form or workflow, but I need it to allow users to retrieve and open it with an actions from the views.
In short, what you want to do is:
Thanks in advance.
Hi @Danny_Reyes,
For the step 2 you have mentioned, Please explore if following approach helps.
I believe it is feasible with following approach . I tested it on "Save File " Work flow type. The solution is based on the approach that instead of taking the AppSheetโs system defined name for the file , the file name can be created beforehand through a column.
2)This file name column ( described in step 1 above) can be used in the โSave fileโ workflow in the field โFile Name Prefixโ as shown in the image below. Apart from file name, the workflow also has โFile Folder Pathโ. After the workflow is invoked, the file gets saved at this designated path with name as captured in โFile Name Prefixโ
3)While calling the action to browse the uploaded file, one can use the โExternal: Open a fileโ type action with file path as CONCATENATE(โMyAttachments/MyCustomers/โ,[AttachmentFileName],".pdf")
The approach may of course need suitable change (say in file name creation ) or may not even work based on how frequently and how many files you need for each record for example.
Hope this helps.
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |