Hi, I have a button I would like to hide if the user hasnt selected a value from a column. Right now I am populating the value selected into a variable, so its like:
vName = Only(Table.Name)
So I would like to evaluate vName so that if it = '', then I will hide the button using the Show Condition. Any ideas how I can do this?
So IF vName = ''
Ah thanks, but the field is a string, not a number, will this make a difference as you have > 0 there. I was expecting ' '...
Nope that works perfectly! Thanks
Any ideas if I can just grey the button out and disable it, as opposed to hiding it?
You don't need to use a variable.
Just right click the button and go to the Background color window. In the "Base Color" area, choose "Calculated" and add your formula. The one shown below set the button background as Blue if the selected value is equal 1 and a light blue if it's not equal 1.
if(Field = 1, ARGB(255, 0, 0, 255), ARGB(50, 0, 0,255))