Status dropdown in form? i'm getting desperate here

Get Help
2

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:

  1. Add a dropdown component.
  2. Set the dropdown list to your Statuses collection.
  3. On your Create or Update action, set the Scanner Request’s Status field to the selected dropdown value.

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:

  • Waiting
  • Completed
  • Problem

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.