I use zapier to link data between Google Sheet to Airtable. The process is when people fill in the form on Jotform, database goes to Google Sheet and I use formula to calculate some data. The result will be in another sheet. Then I use Zapier to link data on the result sheet on Google sheet to Airtable. The problem is every data shows and it’s successful when I tested it but for real situation, some data don’t show on airtable.
Is there any restriction or error that I may made for this process?