How do I do a select list as well as add an a...

(Park Real Estate App) #1

How do I do a select list as well as add an addition to the list of text in quotations?

My select Statement is as follows though I also just want to add an entry to indicate that the user has deliberately stated that the field is blank such as “” or “Not Specified”

=Select(Contact_Records[Full name], [address]=[_ThisRow].[Address])

It this possible or I do I have to go about it another way. I then need the rest of the contact information to pull down for other fields in the form.

(Levent KULAÇOĞLU) #2


={“Not specified”} + Select(Contact_Records[Full name], [address]=[_ThisRow].[Address])

You can also set the Initial Value to: =Not specified

(Levent KULAÇOĞLU) #3

@Suvrutt_Gurjar with your proposition, the required addition will be at the end of the list acquired by SELECT. If the list is too long, then the user will hurdle to find it. It’s always a good approach to place it at the beginning. Just FYI.

(Suvrutt Gurjar) #4

Hi @Levent_KULACOGLU, ,Thank you and I agree with you. As soon as I posted , I saw you had already posted detailed , more efficient approach. As a result, I canceled my post as well. There is always a lot to learn on

efficient, sleek approaches from you, Aleksi and other senior and all community colleagues.

(Marcus Thakur) #5

Damn! Should of thought of that. Thanks.