Hello,
So here is my dilemma: I have to separate forms, station 2 (st2) and station 3 (st3). St2 has serial number values auto filling into SN1,SN2,SN3...etc. fields. A user can choose to change the SN1,SN2...fields by using a checkbox and filling in a re-work SN1,SN2...etc. field. Basically like below:
Current Serial Number (field) Check if Part Needs
Re-Work (checkbox) New Serial Number (field)
This form works fine, but I come to a problem setting up my st3 form. St3 has the same set-up as st2 above (current, check, new) but needs to fill in current serial number field based on whether a new serial number was entered or not. So if the check box = true and new serial number = is not blank then st3 current SN = st2 new serial number. If checkbox = false and new serial number = is blank then st3 current serial number = st2 current serial number.
I think the problem comes down to I have a default view and the st2 and st3 forms are views within a default view form connected to separate lists. I have my rules on the default view form controlled by a button when pressed and a check box that changes the view to st2 or st3 respectively. The problem I am seeing is I can set up rules (above) and get values okay, but when both rules are active, whichever is lower on the rules list takes over and fills in. I tried setting up different conditions for the rules, but can't figure out what I am doing wrong.
Hopefully I explained well enough, if you have questions let me know and any help is appreciated. Thanks.