Help Needed: Pulling Typeform Answers into Bubble Database and Mapping to Appropriate Data Types

[antoine.jennings]

Please pick a subcategory to help organize the information. Thanks!
Hi Bubble Community,

I’m currently working on a project where I need to integrate Typeform with Bubble.io. Users will complete a Typeform survey during the signup process, and I need to capture their answers and store them in my Bubble database. Specifically, I need to map these answers to the appropriate data types and fields in my Bubble database.

Here’s a brief overview of my setup:

1. Typeform Survey:

   • Users provide their first_name, last_name, gender, birthday, etc.
   • The gender question has options: Male, Female, Non-Binary, Other.

2. Bubble Database:

   • User Table: Contains user-specific information including genderID.
   • Gender Table:
     • genderID (e.g., 01, 02, 03, 04)
     • genderType (e.g., Male, Female, Non-Binary, Other)

My Goal:

I want to map the gender answer from Typeform to the corresponding genderID in my Gender table and then assign this genderID to the user’s genderID field in the User table.

Example Mapping:

• Typeform answer “Male” should map to genderID “01” in the Gender table.
• This genderID “01” should then be assigned to the genderID field in the User table.

Steps I’ve Tried:

1. Creating a Backend Workflow:

   • I created an API workflow in Bubble to handle the webhook from Typeform.
   • Added parameters to capture data from Typeform (e.g., gender, first_name, last_name).

2. Searching for Existing Users:

   • Added an action to search for users by email.

3. Conditional Logic for Gender Mapping*

   • Attempted to use conditional logic to map Typeform gender answers to the corresponding genderID.

Issues:

• I’m struggling with adding the conditional logic to map the gender answer to the genderID.
• I’m not sure how the genderID is correctly assigned to the user in the User table.

Request:

I’ve been working on this for a few days and have followed the guides and watched a few videos, but I’m still stuck. Could someone provide a step-by-step guide or example on how to correctly map Typeform answers to the appropriate fields in the Bubble database? Specifically, how to handle the gender mapping and assignment of genderID?

Any help or advice would be greatly appreciated!

Thank you!

[Zeroic]

Hi Antoine! I’ve done some work in this regard sometime back. Feel free to get on a 15-minute call with me to figure this out