Hi, Let’s say that I have a Master Item list and in it I have 2 fields, Pressure and Pressure %. Imagine Pressure is 100lbs and Pressure % is 100%. I’d like to be able to change one and cause the other to update after I use it in a Job because they work together. So if I change Pressure % to 50%, then i need Pressure to change from 100 to 50. I have the correct math but I can’t seem to get these two to work together, it seems it’s one or the other. Thank you. So basically, these fields are fields of an item that is chosen from a dropdown, populated in the job. I don’t mind editing in edit, then saving… or having it work inline but I don’t know if that is possible.
Just to be clear, would you be entering one of them only, or could it be either?
Hi @HarryC,
You could use 2 dynamic fields in your form, one to display the lbs result based on %, the other to display % result based on lbs. Add them to your form below your current select fields, and use display rules like this:
- if lbs field is not blank → hide % select field and show % dynamic field
- If % field is not blank → hide lbs select field and show lbs dynamic field.
The dynamic fields will display the values in real time, but not save them, so you also need record rules to update the record.
Something like this:
- if lbs field is not blank, set % field to the value of (equation field)
- If % field is not blank, set lbs field to the value of (equation field)
Hope this helps!
Martin
Thank you. But can I keep changing them back and forth?
Either and maybe more than once… meaning if I change my mind and want another number or %, I need to be able to do it again. Thank you.
Yes you should be able to just set it back to a blank value to make both select fields display.