Hi,
Is there a way to Display a value when there is an empty table? in this type of useage,
Concat(ComboBox1_1.SelectedItems,"Contact" &"-"&Contact&'Main Number'&'Alt Number' )
Solved! Go to Solution.
HI,
I think I got it to work, when I noticed I wasnt using the & function to call the "if" function, but then it was always displaying the "xxx-xxx-xxxx" .. so I tried this "!IsBlank" and it worked
Concat(ComboBox1_1.SelectedItems, 'ER Phone') & If(!IsBlank(ComboBox1_1.Selected. 'ER Phone'),"","XXX-XXX-XXXX")
Hi @Lmcginnis
You can use the Coalesce function to do this:
Coalesce(Concat(ComboBox1_1.SelectedItems,
"Contact" &"-"& Contact &'Main Number' &'Alt Number'
),
"xxx-xxx-xxx"
)
Hi @Lmcginnis ,
Do you want to display a string as the format of “xxx-xxx-xxx” when one of the fields having a null value?
I’ve made a similar test, you could refer this:
Concat(ComboBox2.SelectedItems,
"Contact"&
If(IsBlank(ComboBox2.Selected. Contact),"","-"& Contact)&
If(IsBlank(ComboBox2.Selected. 'Main Number'),"","-"& 'Main Number')&
If(IsBlank(ComboBox2.Selected. 'Alt Number'),"","-"& 'Alt Number')
)
Best regards,
Community Support Team _ Phoebe Liu
Hi,
Can seem to edit you suggestion to work for my needs.
But yes, if the excel field is blank (a phone number) I would like it to display "XXX-XXX-XXXX" .
my current lable is formatted as,
Concat(ComboBox1_1.SelectedItems, 'ER Phone')
and I have tried,
Concat(ComboBox1_1.SelectedItems, 'ER Phone')If(IsBlank(ComboBox1_1.Selected. 'ER Phone'),"","-XXX-XXX-XXXX")
It doesnt appear to work for me.
Thanks,
HI,
I think I got it to work, when I noticed I wasnt using the & function to call the "if" function, but then it was always displaying the "xxx-xxx-xxxx" .. so I tried this "!IsBlank" and it worked
Concat(ComboBox1_1.SelectedItems, 'ER Phone') & If(!IsBlank(ComboBox1_1.Selected. 'ER Phone'),"","XXX-XXX-XXXX")
User | Count |
---|---|
140 | |
132 | |
79 | |
75 | |
74 |
User | Count |
---|---|
210 | |
198 | |
69 | |
65 | |
55 |