This is the project Iโm working on:
Idea:
A new call on a voip pbx arrives, the pbx trigger appsheet to open the form of the customer who is calling with all information
Implementation:
A VOIP PBX at the restaurant receive calls from customers.
The PBX (Vodia PBX) send an โaction urlโ (a HTTP POST) when a new call comes to Telegram Bot with a URL link of appsheet with row information so that when the admin click on the url, appsheet app opens on the mobile with the right form
Problem:
I need to open not an exact row but a filtered row based on the phone number the pbx sends.
Inside appsheet I can use of course linktofilteredrow() function but what about โoutsideโ appsheet?
I would need a โshort urlโ and not something like:
Is there a better or more elegant and clear way to โtriggerโ appsheet to open a form, view, etc from some app outside?
Maybe I could use Appsheet API to trigger some action/workflow to open the form/view?
Some idea or some workaround? Thanks!
Alessandro
I may be missing something. Are you wanting a link to pull up a form with pre-populated fields from existing rows or a form where the pre-filled data is coming from your link?
If latter, then the long url is unavoidable. Perhaps you could shorten the link with a url shortener?
Iโm wanting a link to pull up a table view, letโs say table โcustomerโ, but with a filter like โtable customer with phone field = xxxxxxxโ, thatโs why Iโm using LINKTOFILTEREDROW(), so yeah I think the very long url is unavoidable and yes, I could try with some url shortener.
I though there was a way to to have some deeplink like https://appsheet.com/xxxx#control=client&filter=, like when I use the search function in a view table.
Ok, gotcha.
AppSheet API triggering an action runs in the server so no, it wonโt help with opening a view on the client side.
You could write a web app (in google apps script or any language you know) that takes the input (such as phone number) as a url parameter and redirects that url to the required long url which it would construct. I donโt have any examples unfortunately but you could perhaps find one.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |