Public Form - Conditional Lookup

Public Form - Conditional Lookup


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.


            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.