Select values that does not have a value in a field with button action

[reshmakala]

Hi,

I have a scenario where I need to make selections in a field if it does not have an entry of another field. I need this as a button action. Can anyone help me please?

Attached are the sample docs.

[maxgro · Accepted solution]

see attachment

added another action to the button

select in field ID

='(' & Concat({$ <ID={"=len(trim(Type))=0"},Priority={High}>} ID, '|') & ')'

[reshmakala]

Thank you so much!!