Way for "guest" to "accept" a job and have it update database
Hey all
I have a system set up to send jobs to our warehouse, which is pretty good except that I don't have a way for them to automatically accept the job (they get sent an email from the DB, and then reply saying received and ok, and then I update a checklist item that is "job accepted").
I'm trying to figure out a way I can maybe have a link in the email that they click to accept the job, which would then update the checklist item in the database for that job?
Any ideas on how this could be achieved? Or some other scenario you think could work? Its the only step in the process that isn't automated and its honestly driving me a little batty, haha.
TIA
2 replies
-
Are you using the Ninox Cloud? If yes, why not include in your email a link to: http
s://app.ninoxdb.de/and have them login and update the checklist themselves?
If you do not want to give them access to your database, then you could create another database with a single form and a submit button.
When they click the button it could do the update using an API post. They would need the record id, but that could be included in the email that you send to them as part of a "password" that they enter with the post.
-
I don't want them to have access to the database. And I'd like to make it as simple as possible for them. Thats why I was hoping for something like a simple link that would send a request I guess, to Ninox to update that particular record...
Otherwise, if there was a way to include a button in the shared HTML view, that would be great. Or something similar. then they could see a list of all the jobs as well as getting the emails (we used to use Airtable, which was great because I could just provide them a share link which would update with any jobs, and they could view all the related documents in that share view as well)
Content aside
- 4 yrs agoLast active
- 2Replies
- 1157Views