Hi..
I am working on a project that needs to have a dropdown menu in a form that will attach a status to it (waiting,completed,problem) i have tried setting up a databse collection for the statuses, but for the love of god i can’t make it work, i can see people here talking about a tutorial about it, but i can’t find it. i would appreciate any help, my app is to help lost dogs find their home by asigning a “chip scanner” from our volunteers all over the country. any help would be appreciated.
Welcome to the community @eternity555
If you already have the Statuses collection set up, the key piece is making sure you have the relationship set up correctly between your main collection and your Statuses collection.
For your app, it may look something like this:
Collections
Scanner Requests
Statuses
In the Scanner Requests collection, add a relationship field to Statuses.
The relationship should be:
A Scanner Request can only have one Status.
A Status can have multiple Scanner Requests.
So a scanner request can be marked as Waiting, Completed, or Problem, but each of those statuses can be used across many different scanner requests.
Then on your form:
So the flow is:
Dropdown selects a Status record → Create/Update action saves that selected Status to the Scanner Request.
One important thing to check: make sure your Statuses collection already has records created, for example:
If the collection is empty, the dropdown will not have anything to show.
Also, if you are creating a new scanner request, use a Create Scanner Request action. If you are changing the status of an existing request, use an Update Current Scanner Request action.
That should get it working.
Thank you so much!! it’s working! you saved me!