My employer requires a strict technical control to ensure that employees can only check in from their authorized workstation. The idea is to automatically capture the user’s public IP address at the time of check-in and compare it against a whitelist of IP addresses stored in Airtable.
The key constraint is that the solution must remain 100% Airtable-based: forms, automations, scripting, with no external front-end, middleware, or proxy server (e.g. Netlify, Vercel, etc.).
However, in our tests, Airtable scripts always return the IP address of Airtable’s servers (AWS), not the end user’s IP. We would like to know if there is any native Airtable method or internal configuration that would allow us to capture the real client IP address directly within Airtable.