Copy to Clipboard- Custom Action Tool

[Rifad]

@Rifad

NEW FEATURE: URL Shortener

Integration I’ve added a URL shortening capability to the service, making it even more versatile for AppSheet users.

How to Use URL Shortener

1. Create a Custom Action in AppSheet

2. Set the action type to “Open URL”

3. Use this formula in the URL field:

CONCATENATE("https://copy-to-clipboard.onrender.com/shorten/", ENCODEURL([Your_URL_Column]))

When users click the action: - A new tab briefly opens - A shortened URL is created and copied to their clipboard - The tab automatically closes - Use cmd + v or ctrl + v to paste the shortened

URL Example: Long URL:

https://copy-to-clipboard.onrender.com/shorten/https://www.google.com

Note: This is not yet completed but can test it out.

This feature is fully developed. You can now use shortened URLs for any AppSheet-related setups.

You can add a share button to link to records, creating short URLs for easy sharing of filtered views.

Here is an example of linktofilteredview:

CONCATENATE("https://copy-to-clipboard.onrender.com/shorten/", ENCODEURL(CONCATENATE(
  "https://www.appsheet.com/start/f86f54ad-as-4366-94a4-aasd",
  "#view=QUOTES&userfilters=",
  ENCODEURL('[["attribute","Quote Label","' & [_THISROW].[Quote Label] & '"]]'),
  "&table=quote"
)))

You can use it to shorten URLs, which specifically helped me with LINKTOROW(), LINKTOFORM(), etc. It copies the shortened URL to your clipboard for easy sharing.

For example, here’s the output: http://copy-to-clipboard.onrender.com/-rBJ3iv.

The original URL I used to create that was: https://copy-to-clipboard.onrender.com/shorten/https://www.google.com.

Let me know your reviews please!

[Fabian_Weller]

Thank you so much @Rifad
This means we have to create a share action for every table right?
It would be cool if the AppSheet system share button would work this way. The Doc says this:

By default, users can share a link to your app with other users by selecting Share in the app menu. Details about how to install the app are populated in an email that you can customize and send to one or more users.

Note: If the current view is a Detail view, the view details are shared instead of installation information.

It would be cool if this Share Button would send the link to the current view.

[Rifad]

Any URL can be shortened. This can be any custom URL to link to Form, Row, View, or even any document. You can also use it for custom URLs to share. It simply copies the URL and shortens it.

[FaCe]

Hi @Rifad for short column text works really very well, i love it.

Unfortunately for long text still not works (at least for me): any chance to fix it ?

I’ve tried with a self-made google script that works but open a new window and not automagically close it.

Your solution is way better, if only long text column would be supported …

[Rifad]

Hi @FaCe How long is your text ? There are character limitations and I am not fully sure about these but this could be potential reason.

[FaCe]

Hi @Rifad i’m in Chrome and for sure i’m below 32.779 characters.

The issue could be caused by special characters ?
In a (short) text i’ve:

Points (.) : 7
Commas (,) : 5
Slashes (/) : 2
Hyphens (-) : 2 (
Euro symbol (€) : 3

[Rifad]

I believe ENCODEURL() will be handling this. Let me test and get back to you.

[Kirk_Masden]

Thanks so much for this fabulous contribution. When you first posted it I was impressed but didn’t feel I needed to use it. Since then, however, it has become clear to me that I need it quite badly in one situation. I works very, very well! Thanks again!

[FaCe]

Hi @Rifad any update on that ? Thank you so much

[BCNRookie]

Do you mind sharing a screenshot of your config? Since I couldnt make It work yet

[Kirk_Masden]

Hi! For background, I share a template version of my app with people. That allows them to use it for free. If they need to migrate their data to a newer version of my app, this helps them transfer the settings, which I’ve put into a single long text string (over 3,000 characters) that the new version parses and then uses to update all of the settings.

That said, the copy to clipboard part of my app is fairly simple.

The interface:

The action:

The formula:

The formula takes the long text string from a single cell in my spreadsheet.

[Rifad]

Thanks for the feedback.

@Rifad

This feature is fully developed. You can now use shortened URLs for any AppSheet-related setups.

You can add a share button to link to records, creating short URLs for easy sharing of filtered views.

Here is an example of linktofilteredview:

CONCATENATE("https://copy-to-clipboard.onrender.com/shorten/", ENCODEURL(CONCATENATE(
  "https://www.appsheet.com/start/f86f54ad-as-4366-94a4-aasd",
  "#view=QUOTES&userfilters=",
  ENCODEURL('[["attribute","Quote Label","' & [_THISROW].[Quote Label] & '"]]'),
  "&table=quote"
)))

You can use it to shorten URLs, which specifically helped me with LINKTOROW(), LINKTOFORM(), etc. It copies the shortened URL to your clipboard for easy sharing.

For example, here’s the output: http://copy-to-clipboard.onrender.com/-rBJ3iv.

The original URL I used to create that was: https://copy-to-clipboard.onrender.com/shorten/https://www.google.com. Let me know your reviews please!

Shorten + Copy this is an amazing setup I use for almost every app now. Sharing a dashboard or row was difficult. I have this setup that copes the URL and its amazing. Best part is the userfilter attribute in the URL helps me define the rows or even single record. @Kirk_Masden

[Rifad]

@Kirk_Masden

The interface:

This is cool. How do you import them, just paste it? Many use cases are opening up for me with this little trick. @Kirk_Masden

[Kirk_Masden]

Thanks Rifad! This would be a very rarely used feature for most users (usually either never or once) of my app. If they DO need to use it they will copy the settings in the old app (via your service) then paste them (as a single long string) into the new app. Then the new app would parse the string and update the settings. That’s necessary because I publish my app as a template that people copy and use for free. Once copied, I can’t update their templates so if they want to move to a newer, better version of my app they need to use this function.

[Freedom_Tang]

Hi @Rifad It’s working fine for me most of the time. But I do encounter one problem. Sometimes when user try to paste the TEXT to certain webpage, the space in between the text become %20 which means:

Text Text

become

Text%20Text

I understand we can use the decode website to solve this, but I wonder is there any workaround to solve this problem? Thanks a lot.

[Rifad]

Hi,

I have never encountered the issue. Please show me your action setup in the app

[Aditya_K1999]

I am using the copy feature. But the URL being copied seems like its getting copied twice or something. what am I doing wrong?

[Rifad]

Probably because using appsheet url column type. Try with normal text type column.