I want to create a single button, using ENUM,...

(Jason Denniston) #1

I want to create a single button, using ENUM, and use the value of that button (if pressed) to show a different field.

The value is a string.

How do I write that in the Show_If box of the field I want to show?

(Santiago) #2

Try . --> Show_IF: [The column with the ENUM]=The value in the button.

(Jason Denniston) #3

This is what I used and it’s not pulling up.

That’s actually what I had in there before.

(Jason Denniston) #4

Here’s the button…

(Aleksi Alkio) #5

ISNOTBLANK([Farmer Mac])

(Jason Denniston) #6

that worked, thanks Aleksi!

(Jason Denniston) #7

@Aleksi_Alkio I’ve got another equation: IF (ISNOTBLANK([Farmer Mac]),[Interest Rate]=[COF]+[Spread], [Interest Rate]=[COF]+[Farmer Mac Spread])

but, I keep getting this error: The expression is valid but its result type ‘Yes/No’ is not compatible with the expected type ‘Percent’

How would I write this so I can see if a field is true, to set the value of a field one way - and, if false, set the field another value?

(Aleksi Alkio) #8

Without knowing your structure you could try… IF(ISNOTBLANK([Farmer Mac]),[COF]+[Spread],[COF]+[Farmer Mac Spread])