Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dataset that looks like this
Name Status Result
Jeff Yes 1
Mark No 0
Tim Yes 1
Sarah No 0
In the field expression editor of both the Result and Status columns, I have used the following to only display those rows with both a 'Yes' in the Status column and a 1 in the 'Result' column, using these lines of code:
=if(Result =1, Result )
=if(Status ='Yes', Status)
So my app now displays :
Name Status Result
Jeff Yes 1
Tim Yes 1
My problem is that I now want the Result column to show 'Accepted' instead of the number 1, as that doesn't make much sense as just an integer so I need text here instead.
Any help would be appreciated greatly.
Thank you
=if(Result =1, 'Accepted')
=if(Result =1, 'Accepted')