bespokeappstt
Hubstaff freelancer
I have a list called 'Equipment' and two elements called SerialNumber and Availability. Availability has the values 'Yes' or 'No' using a dropdown. SerialNumber is self-explanatory. Now there is another list called 'Rental' and it also has an element called SerialNumber that is a 'databasejoin' on the 'Equipment' list, SerialNumber. I want to be able to create entries in the 'Rental' list and every time a 'SerialNumber' is chosen the 'Availability' is toggled to 'No' in the 'Equipment' list for the row of data with that SerialNumber. SerialNumbers are unique and can only be listed in the 'Equipment' list once. Additionally if another row is added to the 'Rental' list, that serial that was previously used is no longer available. It doesn't show in the drop down when adding a new row of data in the 'Rental' list.
It's kind of obvious by now, I'm trying to build an 'Asset Tracking' application. This functionality is the meat and potatoes of it all.
It's kind of obvious by now, I'm trying to build an 'Asset Tracking' application. This functionality is the meat and potatoes of it all.