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
Whatโs your goal?
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.
@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.
Why donโt you use initial value with the formula? Then you can use Editable_If.
@Aleksi_Alkio Ok let me try thatโฆ
That worked thanks. I didnt realize you can have expressions in initial value.
can you give example " Editable_if" logic ?
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:
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |