Need to set a checkbox to YES based on a number field entry on update

[Kurtmc]

As we process our data there is a field that will have an eight digit number or be assigned as zero. Nothing in between. How do I get a checkbox to be a YES if that field value is "0" upon update

[Kronos]

Hi @Kurtmc,

You may use a Triggered Action on your table to set that. Also feel free to use the configuration I've made below: 

This will automatically assign a YES value on your data if the field is equal to 0.

If you don't want the Triggered Action to run upon the insert of data you can remove it on the run actions:

I hope this helps!

[Kurtmc]

Thanks,

I tried something similar to that prior and your triggered action. My problem is that I have a triggered action to automatically assign a unique number based on the month and year. When I change that to "insert and update" it changes that unique number on the update

[Kronos]

Not really sure how you create the unique number but can you try this instead?

If it still doesn't work can you send a screenshot of your trigger? so I can understand more on how your trigger creates a unique number

[Kurtmc]

I Wont allow me to select that field for that calculation

[Tubby]

Do you submit the updates using a DataPage? If yes, you can change the Form Element of the checkbox field to a Calculated Field/Value and follow number 3 in this forum post: 

[cheonsa]

On 1/9/2023 at 4:18 PM, Kurtmc said:

Thanks,

I tried something similar to that prior and your triggered action. My problem is that I have a triggered action to automatically assign a unique number based on the month and year. When I change that to "insert and update" it changes that unique number on the update

Hi @Kurtmc,

Instead of "Insert and Update", create a separate Trigger that runs on Update only, and apply the condition provided by Kronos. In that sense, only the specified field will be updated.

Hope this helps!

 

[WilsonSantana]

To achieve this functionality, you can use conditional logic in your programming code or form builder tool. Here's a general example of how you can set up a checkbox to display "YES" if the field value is "0" upon an update:

Identify the field that will contain the eight-digit number or "0" value.
Set up an event or trigger that is fired upon an update or change in that field.
In the event or trigger code, check the value of the field.
If the value is "0", set the checkbox field to be checked or marked as "YES".
If the value is not "0", uncheck the checkbox field or mark it as "NO".