Filtering Out options from a LookUp field

Filtering Out options from a LookUp field

Hi Everyone

Trying to make a form with a lookup field that will only show things in the Lookup field that do NOT already have a tracking number associated with them in the original report
  1. //once Sample has a US tracking number
  2. //that Sample should never again show up in the SampleLookup (named Samples_Included)
  3. //
  4. //so clear the lookup field
  5. clear Samples_Included;

  6. //get all possible Sample_ID_Descriptions from the Original form
  7. FetchID = Sample_Order_Form[ID != 0].Sample_ID_Description;

  8. //for all records in the oringal form that have NOTHING in the Tracking to US field, add their Sample_ID_Descriptions to the Samples_Included lookup field
  9. for each Sample in Sample_Order_Form [ Tracking_to_US_Office == null ]
  10.     {
  11. Samples_Included.add(FetchID);
  12.     } 

In the form, it just shows "No Matches Found"



Any assistance?

Thanks!!!

      Zoho SalesIQ Resources



            Zoho TeamInbox Resources

              Zoho DataPrep Resources


                  Zoho CRM Plus Resources

                    Zoho Books Resources


                      Zoho Subscriptions Resources

                        Zoho Desk Resources

                          Zoho Projects Resources


                            Zoho Sprints Resources


                              Qntrl Resources


                                Zoho Creator Resources


                                  Zoho WorkDrive Resources




                                      Zoho Campaigns Resources

                                        Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now


                                                      Zoho Show Resources


                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.

                                                                  有料プランをご利用の方