Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there !
I would like to know if it's possible to etablish condition in the help field (the question mark in the legend). In fact, i would like to check if a value is selected in a field and display if it is.
Thank you for your help and sorry for the approximativ english.
=If(not IsNull(GetFieldSelections(specificfield)),
'TEXT' &name_of_record_in_the_specific_field &num(MY_EXPRESSION)&'TEXT',
'TEXT' &num(MY_EXPRESSION)&' TEXT')
regards-bika
Hi,
Yes you can write the if statements and any other conditional statements in Help Text.
Regards,
Kaushik Solanki
Currently my expresion is :
='TEXT' &num(MY_EXPRESSION)&' TEXT'
And I would to get an expresion as :
If nothing is selected in a specific field keep the above expression else ='TEXT' &name_of_record_in_the_specific_field &num(MY_EXPRESSION)&'TEXT'.
Could you help me to find an expression to do that?
Regards
=If(not IsNull(GetFieldSelections(specificfield)),
'TEXT' &name_of_record_in_the_specific_field &num(MY_EXPRESSION)&'TEXT',
'TEXT' &num(MY_EXPRESSION)&' TEXT')
regards-bika
Thank you bika, it works fine. Just one more thing I would like to get le &name_of_record_in_the_specific_field dynamically. Is it possible?
Ok I found. The final expresion is :
=If(not IsNull(GetFieldSelections(specificfield)),
'TEXT' &GetFieldSelections(specified) &num(MY_EXPRESSION)&'TEXT',
'TEXT' &num(MY_EXPRESSION)&' TEXT')
Thank you.
Yes dear..it will work