topic Re: Fill expression IF left blank in App Development

Fill expression IF left blank

robin_heijt — Mon, 23 Jul 2018 07:58:53 GMT

Hi,

I have a table in my app that includes data from several data sources.

All of these data sources are connected by an ID assigned to every person.

But in order to show a persons name with their ID in a table, I would have to add in 4 different columns from 4 different sources to show the names.

I would like to see 1 column for the ID and 1 for the name, so I am wondering if it is possible to write an expression that allows for the name columns to be merged (IF statement maybe).

So if the ID does not match the 1st data source, instead of giving a blank I want it to look for the name in the next data source.

E.g. (Name[source1]IF blank=check name[source2]IF blank=check [source3] etc.....

Cheers.

Re: Fill expression IF left blank

sunny_talwar — Mon, 23 Jul 2018 15:28:09 GMT

May be this

If(Len(Trim(Name_Source1)) > 0, Name_Source1,

If(Len(Trim(Name_Source2)) > 0, Name_Source2,

If(Len(Trim(Name_Source3)) > 0, Name_Source3, Name_Source4)))

Re: Fill expression IF left blank

robin_heijt — Tue, 24 Jul 2018 07:41:23 GMT

Thank you so much!

That worked perfectly!

Appreciate the help.