Editable If.. Is it possible to set and edit...

(Emma Nixon) #1

Editable If…

Is it possible to set and editable if condition on a column that has an app formula? If not any work around? Thanks

(Grant Stead) #2

What’s your goal?

(Emma Nixon) #3

Its a tour package booking system. The agent selects a “package code” in one column, and the column which has the app formula looks up the price.

If the package is a customized package instead of a standard “mapped” package, the price needs to modified manually.

(Grant Stead) #4

@Emma_Nixon got ya… You need another column for manual entry in the mix… One column to select the package, if it’s custom then show if the manual price column and hide the calculated… But no matter what the calculated column does some fancy IF or Switch… If custom then manual column, if package then lookup price.

(Aleksi Alkio) #5

Why don’t you use initial value with the formula? Then you can use Editable_If.

(Emma Nixon) #6

@Aleksi_Alkio Ok let me try that…

(Emma Nixon) #7

That worked thanks. I didnt realize you can have expressions in initial value.