Help with "yesno" updates - set one row to "yes" all others need to be set to "no"

[kmfabercreative]

Hi there,

We have a file upload table that should have one "current" entry, and the rest "not current". I'm planning on setting if an entry is "current" using the "yesno" element (open to suggestions if there's a better way of doing this, in your opinion).

This obviously is easy to setup up; however, when an entry is marked as "current" the rest of the entries in the list need to be marked as "not current", or "no" since it's a "yesno" element.

Would you be able to help me figure out how to make that happen?

Thanks in advance

Cheers.

 

[rob]

If you update from github I've added a "Single yes" option - turn that on and when you save a record with the element's data set to "yes" all other records are set to "no"
For reference here's the commit:
https://github.com/Fabrik/fabrik/commit/e6c2695ad7d4ff8e998acb91cc85e251680118f9

 

[kmfabercreative]

Hey there Rob,

Thanks so much! I'll update and let you know how things work out. Thank you so much again!

Cheers

 

[kmfabercreative]

Hi Rob,

Looks like it works great, thanks again for adding this option!

Cheers

 

[rob]

cool glad to hear it's working for you!