Choice element submits blank value from form

[spa_nick]

Hello all,

I’ll try to explain this clearly, likely I am doing something wrong!

I am using self hosted Baserow.

I have a table in an Application Builder page listing electric heater locations and I have added a ‘Edit’ button to each row:

When this is clicked, it takes the user to a form where they can edit all entries on that row:

“Asset type” and “Buliding” are both “Choice” elements, so users can pick from a list to keep entries consistent.

If I make an edit to the record, say, add a note, and then hit the update button, I get this error: “This field is required” on the two “Choice” elements and they are highlighted red (these fields are required):

If I make those elements as not “Required”, the form will submit without issue, but the entries for those elements in the table will not be populated, i.e. “Asset type” and “Building” will be blank. Obviously, i need all fields not edited to retain their original values.

Here are the properties for the “Asset type” element, in case this might help, it’s very similar to the “Building” element:

Any help here would be very much appreciated.

Thanks,
Nick.

[frederikdc]

Hi,

You need to set both the Option names and Option values for the Choice element. Also, the Value field needs to refer to the id of the first element (index 0).

So the final result looks like this (I’m using a single select field to indicate the Status of a task as an example)

[spa_nick]

Hello @frederikdc,

Many thanks for your help here, this is what i have now although I am still experiencing the same issues.

Thanks again,

Nick.

[frederikdc]

Your properties Option names and Option values both refer to Building > [All] > value

This should be the value for Option names and the id for Option values.

• Option names: Building > [All] > value
• Option values: Building > [All] > id

[spa_nick]

hello @frederikdc,

Thanks again - now I have this but the error is still there:

Thanks,

Nick.

[frederikdc]

It seems to be ok at first sight. Maybe removing the Placeholder value might help?

[spa_nick]

Hello @frederikdc,

Thank you - if I remove the placeholder, the value in that field defaults to ”Make a choice”, instead of displaying the value that is stored in the table, like this:

Thanks,
Nick.