Expression help

[satishkurra]

Hi All

I have the expression below where it should display the below column values (answer_....) when we select Other on the UI and for other than OTHER, it should show the selections made

For example Behavioral Health has other values as Not Required and Required, if we select Required or Not Required, it should display that value

For example Services has other values as Not Required and Required, if we select Required or Not Required, it should display that value

if([Behavioral Health] = 'Other', answer_text_short_bhh,

if(Services = 'Other', answer_text_short_spp,

GetCurrentSelections()))

Can someone help me on the same?

Thanks

Satish

[sunny_talwar]

Would the selection be made in only one of them or can be made in both? I am getting confused of how the user will interact with the application. Can you elaborate?

[satishkurra]

if the user selects Other, it should display the values from Others, if they select Required or Not Required it should display accordingly.

In the similar way i have other columns where it has Other, Required and Not Required Columns

At the end the user will select only 1 value at a time.

Hope it is clear

[sunny_talwar]

May be this:

If(FieldName = 'Other', 'SomethingYouWantUserToSee', FieldName)

[satishkurra]

But the problem is i cannot close the if condition because i have other field names as well.

Infact i tried before the option you provided.

[sunny_talwar]

So lets take a scenario. If have two fields

Field1

Other

Required

Not Required

Field2

Other

Required

Not Required

If in either of them the user selects Other you would want to show text otherwise both of their content?

[satishkurra]

Hi Sunny

Let me put here in an example. Apology for the confusion

LOAD * Inline [

Facility

Required

Not Required

Other ];

LOAD * Inline [

Services

Required

Not Required

Other ];

if user selects Other in Services, it should display values for Other for Services,

if user selects Other in Facilities, it should display values for Other for Facilities,

if user selects Required in Services, it should display values for Required for Services,

if user selects Required in Facilities, it should display values for Required for Facilities,

if user selects NOT Required in Services, it should display values for Required for Services,

if user selects NOT Required in Facilities, it should display values for Required for Facilities,

All the above condition should be achieved in 1 single expression.

Request to please let me know if it is not clear.

Thanks

Satish

[satishkurra]

Sunny we can write 3 conditional expressions for facilities and other 3 for services, but the data contains 5 tables like facilities and services with not only Other, Required and NOT Required, we have many other field values...

[sunny_talwar]

One last question. When you say values are you referring to the three values we see for services here?

Satish Kurra wrote:

if user selects Other in Services, it should display values for Other for Services

or is it another field's values?

[satishkurra]

Yes Sunny