Hello. Can someone tell me the best way to set a field value based upon another field in the same form?
Say I have:
Field3: Yes or [empty]
Here is what Id' like to do. I'd like to update Field2 with the value from Field1 but based upon text is Field3. If Field3 has a "Yes" then I'd like to update Field2 with the value of Field1 adding 7 hours to the value. If Field3 is empty I'd like to update Field2 with the value of Field1 adding 17 hours to the value.
I have tried various functions like "Rules for Field Def" or "Field Definition" with formulas but what I'm seeing is the form (Field1 selected twice) has to be updated twice to be able to switch between the values correctly. What I need is when Field1 changes anytime, update Field2 with the proper values outlined above.
I looked into the IF statement but I don't know if that can be used in the Rules macro or not. I'm not finding much in the samples. But I'm still looking. If anyone knows, then please get back to me.
There could be multiple approaches, including the one with formula or setting the expression (instead of Set Value action in "ConfiForms Field Definition Rules" macro)
Here is the one (on many) solutions that you can implement
Also, you may want to ask ConfiForms to calculate a bit more (probably will make it better maintainable in the future)
See, here I am asking to calculate 7 hours for me in milliseconds
Happy New Year, everybody! What better way to kick off 2022 than with a new Marketplace Partner Spotlight ✨ This month, we're getting to know Daniel Franz, co-founder of Fine Software. Fine Software ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events