How to send Google File link through the SMS workflow

Hello I’ve created a messaging app that allows the user to send SMS and emails to a list of users. They have the ability to upload images and files. When I send the mass emails out both the photos and files are sent out as attachments in the email. But when I go to send the SMS I only have the option to attach the photos, not the files. I’d like to include a link to the files from my google drive. Is there a way to do this through the SMS workflow?

You can send the URL directly in the SMS body text. All mobile devices will interpret that part as a clickable URL.

3 Likes

I tried that last night and it almost worked… unfortunately the SMS is limited to 160 characters so the url was truncated.

The actual file url is:
https://www.appsheet.com/get/?i=YXBwTmFtZT1OZXdBcHAzLTE1MjcyMjQmdGFibGVOYW1lPUZpbGUlMjBVcGxvYWRzJmZpbGVOYW1lPUZpbGUlMjBVcGxvYWRzX0ZpbGVzXyUyRjA4LTI0LTIwMjAlMjAxMy01Mi01NS5GaWxlLjIwNTMzOC5wZGYmYXBwVmVyc2lvbj0xLjAwMDQ1NiZzaWduYXR1cmU9Mzc4MzUxOWFhZjE2MDhlNzcxNzRjYzRlMzY4OThkY2RhNTU1NDlkNTNkZmQyZWZhZmRkY2JiN2QzMTIwZWZkYjYzOWMyYmQ4Y2M1ZDlmZjM0YjUyMzkxODFkNTE5NDhl

But it gets truncated down to:
https://www.appsheet.com/get/?i=YXBwTmFtZT1OZXdBcHAzLTE1MjcyMjQmdGFibGVOYW1lPUZpbGUlMjBVcGxvYWRzJmZ

I tried to add <<HYPERLINK([File],“Download File”)>> into the body, but that didn’t seem to work. Any more ideas would be much appreciated! Thanks

I also tried to do a link directly to the Google Drive where the document is located using =CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=", ENCODEURL("AppName-Account#"), "&tableName=", ENCODEURL("TableName"), "&fileName=", ENCODEURL(+ImageColumnCell)) and filling in my data for table name, etc, but that didn’t work either.

2 Likes

@LeventK @Tim_Lunney

sir,
i m also trying this same way for SMS action that person can see invoice or document short name in SMS. that looks like professional also please provide any ideas