Default value when Ref coulmn is empty

[HCF]

Is it possible to show a default value in a Ref column when this field is empty.
Like, the user does not select anything from the list or “clear” the selection in the list?

[Suvrutt_Gurjar]

If I have understood your requirement correctly, please try following.

You could have a key value of the parent table that you to have as a default reference value in the child table’s ref column’s initial value.

[HCF]

@Suvrutt_Gurjar - thanks, but not sure if I understand your reply. Could you elaborate?

[Suvrutt_Gurjar]

Please see the settings of the reference column in the child table ( a sample below)

Ref column in the child table

Initial value of a parent table’s key in the reference column. The key value needs to be that of the parent record that you wish to be default value if the user does not select a reference from the dropdown.

[Steve · Accepted solution]

HCF:

Is it possible to show a default value in a Ref column when this field is empty.

Nope.

[Suvrutt_Gurjar]

HCF:

or “clear” the selection in the list?

Hi @Steve,

Thank you for correcting my bad. Got it now. I had missed this above statement.

HCF:

the user does not select anything from the list

I believe this is possible in specific cases if the ref column is for the second parent table , such as Product ID referencing Product table in Order Details form where the main referencing is on Order table as parent.

Or am I still missing something?

Overall, my bad that I used an incorrect test case to answer the question. As the screenshots show, I tested it on the second reference column ( Products table)

Thank you for correcting it.

[amunizp]

Yep, I tried:

text(top(Checkin[Name], 1))

or trying to get the value [0] from the list 

But all it does is this in which the app puts in a default value but does not understand that it is one of the items of the list.