Forum Discussion

olivermah's avatar
olivermah
Qrew Assistant Captain
7 years ago

button to update a field only when another field value = X

I'm trying to create a button where the user can push it to change a value in the field to one that is specified by the user.  however only when another field is equal to a certain value. the below co...
APIs and custom code
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Sure, an IF can be as long as you like.

IF(
[Another Field] = "X"
and
(FirstDayOfMonth([date field])=FirstDayOfMonth(Today())
or
FirstDayOfMonth([date field])=FirstDayOfMonth(AdjustMonth(Today(),1))),

"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"

)