bespokeappstt
Hubstaff freelancer
Here is a sample of a list called Rentals that I have:
The user role that 'Edits' this list has to edit the Serial Number element and the Actual Date In Element at different times and it's causing an issue. The Serial Number will be entered in first, then some time will pass and the Actual Date In has to be entered. The Serial Number is a database join on another list called Serial Assets. Serial Assets have an Available element, a dropdown(yes/no). When Serial Numbers are added to the Rental list, using a php-calc plugin on the Rental list the Availability is toggled to no in the Serial Assets list. When set to no you won't see it and can't add it to this list which is the Rental. This is because in the database join for the Serial Number I have a 'join where specified' as shown below, yes=1 and no=0
This works fine when adding new serials to the Rental list as serials cannot be entered twice. However, when its time to add an 'Actual Date In',(later down the road) the Serial Number information is disappears. How can I get the serial number to be permanent while I edit the 'Actual Date In' alone? If I have to do a video on this one I will, its quite a mouthful to explain. If anything requires clarification I will clarify.
The user role that 'Edits' this list has to edit the Serial Number element and the Actual Date In Element at different times and it's causing an issue. The Serial Number will be entered in first, then some time will pass and the Actual Date In has to be entered. The Serial Number is a database join on another list called Serial Assets. Serial Assets have an Available element, a dropdown(yes/no). When Serial Numbers are added to the Rental list, using a php-calc plugin on the Rental list the Availability is toggled to no in the Serial Assets list. When set to no you won't see it and can't add it to this list which is the Rental. This is because in the database join for the Serial Number I have a 'join where specified' as shown below, yes=1 and no=0
This works fine when adding new serials to the Rental list as serials cannot be entered twice. However, when its time to add an 'Actual Date In',(later down the road) the Serial Number information is disappears. How can I get the serial number to be permanent while I edit the 'Actual Date In' alone? If I have to do a video on this one I will, its quite a mouthful to explain. If anything requires clarification I will clarify.