LinkedIn
Twitter
Hi everyone, please share your feedback on the copy-to-clipboard feature—I'd like to know if it's useful and working well.
I'm developing a new feature for the AppSheet notification system. Let me know if this will be beneficial. This is a Chrome extension that's not yet approved; I’ll provide access to everyone once it’s approved by the Chrome Web Store and after some testing.
@Rifad wrote:
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! 🙂
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.
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.
@Kirk_Masden wrote:
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
Thanks for the feedback.
@Rifad wrote:
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
