Hi friends,
Is there any possibility to substitute long links in embedded appviews by short names as in this photo:
I want to substitute the long links with clickable names to open pdf file.
Best regards,
Yes, generally it can be done by using HYPERLINK() function.
1 Like
I have a column from which I display the link named File with display name :PDF Checklist with the following Image/File folder path:CONCATENATE(“Files/”, [ID], " - ", [Matricule Camion], “.pdf”).How to make use of Hyperlink in this case?
How the file is saved or created -is it saved by the user by uploading through form or is it created by bot?
Also the CONCATENATE() based expression you have shared and the one in screenshot you have shared appear to be different. Could elaborate why?
1 Like
The pdf file is created in a bot using an action “Create PDF Checklist” with
set the values of some columns in this row:
File=:CONCATENATE(“Files/”, [ID], " - ", [Matricule Camion], “.pdf”)
And here is my column setup:
Here is also the setting of my bot:
if you are using the action to set the entire file path as above, then please test by removing the expression in the “Image/ File Folder Path” setting.
1 Like
I have removed the “Image/ File Folder Path” setting and the bot is normally creating the pdf file , but how to use hyperlink to display the file without the long link above?
If it is file type column it should display only file name.
1 Like
Yes the column is of type File as shown above in the screenshot ,but when it comes to the embedded appview is displays as follows:
I am able to display the file generated by the bot.
The bot pane with relevant settings of attachment name and folder path
Attachment Name expression
<<CONCATENATE([Order ID], “-”, TEXT([order Date],“YYMMDD”))>>
Attachment Folder path expression
CONCATENATE(“Orders/”,[Customer Name])
The file column in the table (VC) called [Order_File] expression
CONCATENATE(CONCATENATE(“Orders/”,[Customer Name]),“/”,[Order ID], “-”, TEXT([order Date],“YYMMDD”),“.PDF”)
This is basically concatenation of attachment folder path and attachment name expressions in the bot mentioned above.
The file column looks like below in detail view with file name
if the user taps on the file name it opens.
Hope this helps.
1 Like
I have already the files displayed in the form detail used as embedded appview as you can see:
But the problem is when sent via email ,the file is displayed as long link
If you want to send a link, unless you use an address shortener (tinyurl.com, for example), the full address will appear in the email.
Another option is to send the file as an attachment instead of the file address. To do this, you will need to use a bot and Google Apps Script.
I am able to properly see the file name. Here is the emai body received from bot. I can see the link with the file name.
And here is the template in which the File column , [Order_File] that I referred earlier is used.
1 Like
But in my case I am using an embedded appview and not a simple template, because I want the user to interact with form by clicking either Bloquer or Annuller as you can see here:
I am aiming at making this form smaller to include other info
Sorry it is getting a bit more confusing. The Bloquer or Annuller appear to be enum buttons. What is their relationship with the links?
If you are only referring to links, yes, they do not even open in embedded app view. Are you able to open the files with those long links?
1 Like
Yes ,I can open them .The user before blocking or cancelling the operation ,he has to check the checklist and the sd form attached in the appview
You mean, you can open them in the embedded app view?
1 Like
Absolutely yes
Okay, got it. I am also getting a long URL in the embedded view. Will perform more testing and revert if that can be shortened.
1 Like
Ok ,I will try in my turn to get a solution
1 Like