I have made a zap but I am facing issue of not getting all results in airtable and I am only getting last data entry in table and not all 10.


Okay, here's a breakdown of my current Zap steps (using the Filter + Storage method) and the reason for each:

1. New Submission (Youform Trigger):
   • Reason: To start the automation whenever a client submits the booking form and capture their input.
2. Find or Create Client (Airtable Action):
   • Reason: To look up the client by email in your Clients table or create them if they're new. This provides the correct client Record ID needed for linking and avoids duplicates.
3. Split Services (Formatter Action):
   • Reason: To take the comma-separated text of selected service names from the form and turn it into a list of individual service names that the loop can process one by one.
4. Create Loop From Line Items (Looping Action):
   • Reason: To repeat the next set of actions (Steps 5, 6, 7) once for each individual service name identified in Step 3.
5. Find Services (Airtable Action - Inside Loop):
   • Reason: To search your Services table using the name of the service for the current loop iteration and find that service's unique Airtable Record ID. This ID is needed for linking later.
6. Push Value Onto List (Storage Action - Inside Loop):
   • Reason: To take the unique Record ID found in Step 5 and add it to a temporary list associated with this specific Zap run. This is intended to collect all the required Service IDs across all loop iterations. (Note: We suspect this or Step 9 is malfunctioning internally, as unique IDs go in but duplicates come out later).
7. Filter (Filter Action - Inside Loop):
   • Reason: To check if the current loop iteration is the last one. It stops the process for all iterations except the final one, ensuring the subsequent steps run only once after all services are processed.
8. Find Assigned Member (Airtable Action - After Filter):
   • Reason: To run once on the final loop iteration. It finds the selected practitioner in your Team Members table to get their Record ID for linking.
9. Get List Values (Storage Action - After Filter):
   • Reason: To run once on the final loop iteration. It retrieves the complete list of Service Record IDs supposedly collected by Step 6. (Note: This step is outputting incorrect data - duplicate IDs - despite apparently correct configuration).
10. Create Booking (Airtable Action - After Filter):
    • Reason: To run once on the final loop iteration. It creates the actual booking record in Airtable, using the Client ID (from Step 2), the list of Service IDs (from Step 9), the Member ID (from Step , and other form details to create the complete, linked booking.