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