Formula hide button action

Hello everybody
I have an action button that inserts the current time into a column. with the formula below it is shown only if: IN ([service], {815,814}).
How can I toggle the button when pressed?
IN ([service], {815,814}) isblank ([service] โ€ฆ

Solved Solved
0 6 499
1 ACCEPTED SOLUTION

Hi, if i understand correctly, you want to enter a Time in a time column ONLY IF the [service] is equal to 815 or 814. Once the time is entered, then you want the button to go away.

If correct, then I think you want an expression like the following:

AND(IN([service], LIST(815,814)), ISBLANK([Time Column]))

View solution in original post

6 REPLIES 6

Add a status column [Filled], type Enum with the values Yes/No
1โ€™st action to set [Filled] to Yes (Do not display - Appearance section- Prominence)
2โ€™nd action to insert the time (Do not display - Appearance section-Prominence)
3โ€™rd action to run action 1 and 2 (Grouped: execute a sequence of actions)

Set the 3โ€™rd actionโ€™s display type in Appearance section-Prominence
Then a bit bellow on Behaviour section, Only if this condition is true :
[Filled]=โ€œNoโ€

Hiand thanks for your answer.
But isnโ€™t there a way to use the formula directly in my example?

Never thought about it as I got that solution and just used it but this should work:

ISBLANK([Service])

(in Behaviour section)

Hi, if i understand correctly, you want to enter a Time in a time column ONLY IF the [service] is equal to 815 or 814. Once the time is entered, then you want the button to go away.

If correct, then I think you want an expression like the following:

AND(IN([service], LIST(815,814)), ISBLANK([Time Column]))

I thank you for your helpโ€ฆ
If you would like to add another condition as well, as in the example I added to your expression
AND(IN([service], LIST(815,814)),[setting]="ok "ISBLANK([Time Column]))

Thanks!!! a lot

Top Labels in this Space