Seriously STUMPED
I have an inventory form and I'm working on an auto order process. Any part that falls below the users preset levels is displayed when the user clicks on the button [Auto Order]. I populate the items to a checkbox list to allow the user to select which items they may want to order.
I just discovered zoho does not place any value on a loop "do, for, while" which is the part that really has me "CONFUSED". Using a loop it would be an easy process to extract the quantity, part number and description back out of the string of items selected by the user.
Quantity = 1, Part Number = 100089979, Description = PTZ Camera and lens
Originally I loop through the records in [My_Inventory] form to get this information;
for each rec in My_Inventory [((Tech_ID = User.Employee_ID && Units_On_Hand <= ReOrder_Point) && Part_Type = input.Part_Type)]
and put it into a checkbox for the user to view and select.
? Any thoughts how I can achieve my desired results to get the Quantity and Part Number out of the string selected by the user. ??
I just discovered zoho does not place any value on a loop "do, for, while" which is the part that really has me "CONFUSED". Using a loop it would be an easy process to extract the quantity, part number and description back out of the string of items selected by the user.
Quantity = 1, Part Number = 100089979, Description = PTZ Camera and lens
Originally I loop through the records in [My_Inventory] form to get this information;
for each rec in My_Inventory [((Tech_ID = User.Employee_ID && Units_On_Hand <= ReOrder_Point) && Part_Type = input.Part_Type)]
and put it into a checkbox for the user to view and select.
? Any thoughts how I can achieve my desired results to get the Quantity and Part Number out of the string selected by the user. ??