Learn how to add age-based conditions in Pabbly Connect Workflow using Google Sheets and form submissions to automate data handling based on user age. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.
Watch Step By Step Video Tutorial Below
1. Creating a Workflow in Pabbly Connect
To start using Pabbly Connect, first, sign up for a free account. Once logged in, navigate to the dashboard and click on ‘Create Workflow’. Name your workflow, for example, ‘P Form Builder to Google Sheets’. This workflow will help automate data handling based on user age.
After naming your workflow, click on the ‘Create’ button. You will see two windows: the trigger window and the action window. The trigger window is where you set up the initial event that starts the workflow, while the action window is for the subsequent actions that will occur based on the trigger.
2. Connecting the Trigger Application in Pabbly Connect
In the trigger window of Pabbly Connect, select the application that will initiate the workflow. For this example, we will use P Form Builder. Choose ‘New Form Submission’ as the trigger event. This setup allows Pabbly Connect to capture user data from form submissions, including their date of birth.
- Select ‘P Form Builder’ from the app list.
- Choose ‘New Form Submission’ as the trigger event.
- Copy the webhook URL provided by Pabbly Connect.
Next, go to your P Form Builder account, edit your form, and navigate to the Integrations page. Paste the copied webhook URL into the designated field to connect it with Pabbly Connect. Once saved, return to Pabbly Connect and click on ‘Recapture Webhook Response’ to ensure the connection is successful.
3. Calculating Age Based on Date of Birth
After successfully capturing the form submission data, the next step in Pabbly Connect is to calculate the user’s age based on their date of birth. This is done by comparing the current date with the date of birth provided in the form submission.
To achieve this, add an action step in Pabbly Connect and select the ‘DateTime Format’ app. Choose ‘Current Date’ as the action event. This will give you today’s date, which will be used for age calculation.
- Select ‘DateTime Format’ from the app list.
- Choose ‘Current Date’ as the action event.
- Set the date format to ‘Day-Month-Year’.
After obtaining the current date, add another action step using the ‘DateTime Format’ app and select ‘Date Duration Calculator’. Map the date of birth from the trigger response and the current date to calculate the user’s age.
4. Setting Age-Based Conditions in Pabbly Connect
Now that we have calculated the user’s age, it’s time to set up conditions based on that age within Pabbly Connect. This involves creating two routes: one for users aged 18 and above and another for users below 18.
In the action window, click on ‘Add Action Step’ and select ‘Router’. This allows you to create different paths for the workflow based on the age condition. Name the first route ’18 and Above’ and the second route ‘Below 18’. Set up the filter conditions accordingly.
For the ’18 and Above’ route, set the filter condition to ‘Result Years > 17’. For the ‘Below 18’ route, set the filter condition to ‘Result Years < 18".
These conditions will ensure that form submissions are directed to the appropriate Google Sheets based on the user’s age, allowing for efficient data management.
5. Adding Data to Google Sheets Based on Age
The final step in this automation process using Pabbly Connect is to add the form submission data into the correct Google Sheets based on the user’s age. For users 18 and above, you will map the data to a designated sheet for adults.
In the action step for the ’18 and Above’ route, select ‘Google Sheets’ and choose the action event ‘Add New Row’. Connect your Google Sheets account and select the appropriate spreadsheet and sheet for users aged 18 and above. Map the fields from the form submission to the corresponding columns in Google Sheets.
Select the spreadsheet and sheet for users aged 18 and above. Map the form submission data to the respective fields in Google Sheets.
Repeat this process for the ‘Below 18’ route, selecting the appropriate sheet for users under the age of 18. This setup allows for seamless data handling based on age, demonstrating the power of Pabbly Connect in automating workflows.
Conclusion
In this tutorial, we explored how to add age-based conditions in Pabbly Connect workflows, integrating Google Sheets and form submissions. By setting up triggers, calculating ages, and directing data based on conditions, you can effectively manage user data based on age. This automation not only saves time but also enhances data accuracy in your workflows.
Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.
- Check out Pabbly Connect – Automate your business workflows effortlessly!
- Sign Up Free – Start your journey with ease!
- 10,000+ Video Tutorials – Learn step by step!
- Join Pabbly Facebook Group – Connect with 21,000+ like minded people!