Public Form - Conditional Lookup

Public Form - Conditional Lookup

Hi,

I'm relatively new to Zoho Creator, but I'm making a recruitment database and want applicants to select a drop down of our 'live' recruitment rounds. In the recruitment rounds I have a tick box 'live on website'. I'd like only these jobs to show up in the look up on the public form - but for the admin user to see the whole list of old jobs? How best to achieve this?

I looked at filtering the lookup on recruitment rounds, but this will filter the field for public submissions AND for admin users. I just want the public users to only see the 'live on website' jobs.

Thanks,
R

            Zoho DataPrep Resources


                Zoho CRM Plus Resources

                  Zoho Books Resources


                    Zoho Subscriptions Resources

                      Zoho Desk Resources

                        Zoho Projects Resources


                          Zoho Sprints Resources


                            Zoho Orchestly 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 Writer Writer

                                                      Get Started. Write Away!

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