Best way to fetch employee names from Zoho People into Zoho Creator Inventory Stock Form field Employee Name Lookup

Best way to fetch employee names from Zoho People into Zoho Creator Inventory Stock Form field Employee Name Lookup

Hi Team,

I have a requirement in my Zoho Creator application (Inventory Stock Adjustment) where I need to fetch employee names from Zoho People and use them as a lookup in a form.

Currently, I am considering using an integration field to fetch this data directly from Zoho People. However, I am concerned about potential limitations such as:

  • Real-time synchronization of employee data

  • Lookup field behavior and duplicate entries

  • Dependency on Zoho People field structure changes

  • Limited customization options in Creator

I would like to clarify:

  1. Is using the integration field the recommended approach for this scenario?

  2. Are there alternative approaches to reliably fetch and maintain employee names in Creator forms while ensuring smooth lookup functionality (e.g., syncing data to a native Creator form, using APIs, or scheduled workflows)?

  3. Which approach would you recommend for best performance, reliability, and maintainability?

Your guidance will help me implement the most efficient and robust solution for integrating Zoho People employee data into my Creator forms.

Thanks in advance for your support.