Setting a Dropdown's Initial Value

Maybe a basic question here but it’s puzzling me.

I am using a couple of dropdowns in an RE, that reference a person in the database. There’s alse several of inputs, and they can all display the person’s information as an initial input.

How can I achieve the same effect with the dropdown? Without pulling the value from the database, the dropdown wipes the value when the form is saved.

@QIRO have you tried using the Default Value field?

The default value doesn’t grant the same access as the other fields.

image

The “Parent’s group” doesn’t work either. If you set the parent’s group it won’t accept the value because it’s looking for a column but it only seems to go as deep as the row.

image

Very high chance I’m being daft, but this is a new one for me.

It seems that the Location field in User is of type text, not Location?

Could you try adding a new field Location New (of type Location, not text) in User, and use it to store the Location object, not the Station text.

This way you would be able to choose Parent Group’s Driver’s Location as the default value in the dropdown

Let me know if that works

Well now! I hadn’t even considered that the data field might be the issue!

Nice work, thank you very much. I had indeed stored the Location as text, instead of a location.

1 Like

No problem! Glad I could help