I have an App where I'd like to automate searching for an NFC tag simply by the user touching phone to an NFC tag. IF THE ITEM DOESN'T EXIST THEN A RECORD IS AUTOMATICALLY CREATED
The only way I can think of to deliver this functionality is
What I'm expecting is
What it does is
This means I can't automate the search process without user input. and I can't automate the automatic creation.
What I need is a deep link such that a record is created *AND SAVED* without any user input.
I scoured the Appsheet Q&A and the answer isn't included in
https://help.appsheet.com/en/articles/1023058-app-column-type-deep-link
https://www.googlecloudcommunity.com/gc/Tips-Tricks/META-POST-Deep-Links-URL-Parameters/m-p/349632
Any ideas?
Not possible.
Is it possible to trigger an event directly using a URL? Then all kinds of automation could ensue?
You could certainly create your own api to make a change to your database using an url call. If I was in your situation I would probably make an Azure Function App to apply your required business logic. If you wanted to stay in the low code space and your database is stored in Google Sheets, maybe you could make a Google Apps Script to either take a user to an Appsheet link or create a new record in the Google sheet and then take the user to the Appsheet link.
Oh dear. That's not very "can-do" @Steve
๐คฃ
In that case is it possible to trigger the add using API using a https:// link that adds (POSTS) a record?
There must be a solution that get's me close. It's surely just a question of ingenuity.
And may I ask why this is fundamentally not possible. Is that intentionally made impossible because it would lead to bad things?
It's pretty cool that you can start an Appsheet app using an NFC tag!
I think the limitation comes from the fact that there is no NFC-based trigger for Appsheet automation.
Do you have to capture the search info users submit as a new record to a table? Or could you apply the search info as a url parameter using the in-app filter? Something like this: https://www.appsheet.com/start/722f8a69-cdbe-4e10-9a02-b55e63cce457#appName=InventoryManager-2078346...
Here is the announcement for in-app filters: https://www.googlecloudcommunity.com/gc/Announcements/In-App-Filtering-available-for-General-Availab...
This is genius ...
But one question about the link https://www.appsheet.com/start/722f8a69-cdbe-4e10-9a02-b55e63cce457#appName=InventoryManager-2078346...
Where did you generate this code from? And where are useful features for encoding URLs documented. For example where is it documented that you can do &userfilters= in a URL?
Is there a full documentation of everything you can do with URLs with all the possibilites?
I don't know if there is full documentation with how urls are created when using an in-app filter. I just went to a template app that AppSheet provides and applied an in-app filter.
Here is where you can view the app:
This was the page I applied my search:
Users can customize their own in-app filter by clicking this icon:
And I've had a think about the second bit of genius with your reply.
You point out the root cause of the issue.
@KingsGuava wrote:I think the limitation comes from the fact that there is no NFC-based trigger for Appsheet automation.
That's exactly right.
Do you think that this would be valuable?
I think this feature would be super valuable! If there isn't already a feature request please create one and you'll get my vote ๐
Since Appsheet is a low code platform that excels as in mobile development I think it would make sense for mobile-based features to be prioritized. There are a dozen of low code platforms that excel in web development so this could be another feature to set Appsheet ahead of the pack.
If you want to show a filtered view, why don't you use the right tool for the job?
My only concern with LINKTOFILTEREDVIEW() is that I don't think users can "unfilter" the view. By passing the in-app filter conditions, users can remove or add as they see fit.
Yes but he needs a link to a view that's filtered with no interaction with the app, so it's the right tool.
For sure we can make better or bigger filtered views with dynamic dashboards and more
@KingsGuava
You are right that the filter will do what I asked....
And for me the search URL is the best tool and better than LINKTOFILTEREDVIEW() because I can encode that url on the NFC chip.
However, (sorry to frustrate you) ... there is a reason why it doesn't quite do what I need ...
I need to update the first post....
It should read:
I have an App where I'd like to automate searching for an NFC tag simply by the user touching phone to an NFC tag. IF THE ITEM DOESN'T EXIST THEN A RECORD IS AUTOMATICALLY CREATED
Since
it would be logical to expect that the record is saved. Yet it is not.
Two questions that you may be able to illuminate @SkrOYC or @Steve
AppSheet does not work this way. Badgering us isn't going to change it.
I accept the reprimand, and sorry for badgering.
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |