Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
May be this:
If(FieldName = 'Other', 'SomethingYouWantUserToSee', FieldName)
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.
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?
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
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...
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?
Yes Sunny