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

Emma_Nixon · 06-29-2018 05:00 PM

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

What’s your goal?

Emma_Nixon

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

@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

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

Emma_Nixon

@Aleksi_Alkio Ok let me try that…

Emma_Nixon

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

Yayasan_TL_BP

can you give example " Editable_if" logic ?

Steve

Editable only if adding a new row (disallow updates):

NOT(IN([Row Key], Table[Row Key]))

Editable only on Mondays:

(WEEKDAY(TODAY()) = 2)

Editable only during business hours:

AND(
  (TIMENW() >= "08:00:00"),
  (TIMENOW() < "18:00:00")
)

Editable only by designated app admins

("Admin" = USERROLE())

Editable only by specific users:

IN(USEREMAIL(), LIST("joe@example.biz", "mary@example.biz"))

I’ve also added examples to the doc: