Answered

Custom Variables showing up in notifications and Google Sheets???


Userlevel 2
Badge +1

Why do custom variables show up in the notifications and google sheets?  How can I hide or remove this?

 

icon

Best answer by Liz 22 July 2021, 14:49

View original

12 replies

Userlevel 7
Badge +5

Hi @coop3254 Welcome to the community! If you have selected the option to include all responses in your notifications, the custom variables will be included in this. To remove this option, you’ll need to manually add each question you’d like to appear in the responses instead of selecting all. 

I hope this helps! Let me know if you think of any other questions. 

Userlevel 2
Badge +1

Thanks!

Userlevel 7
Badge +5

Welcome, @coop3254 ! Let us know if you think of any other questions/suggestions!

Hi @Liz - can you point me to where I can adjust that option? I have custom variables that aren’t showing in my google sheets and I’d like them to!

Userlevel 7
Badge +5

Hi @Alaub The custom variables should automatically send to Google Sheets (as it’s not possible with the native integration to adjust what sends there). Do you have the form published by chance? If not, you’ll want to be sure to publish the changes!

Userlevel 1

Hi @Liz speaking of custom variables, do you know if it is possible to export custom variables to Active Campaign via the integration?

Userlevel 7
Badge +5

Hi @ianroderick I’ve responded to your post with an answer! :) 

Userlevel 1

@Liz thanks! yes the issue is resolved. Basically, it is not possible to get the variables from Typeform to Active Campaign.

So now the flow will be Typeform → Google Sheets → Active Campaign

Userlevel 3
Badge +2

 

Yeah. I went from this easy to read results.

How can I make the new results easier to read?


Your typeform Permanent Make-up Course has a new response:

  • Which course are your registering for?
    Lip Tattoo
  • Great! Can we get your first name please?
    wriyt
  • Hi Alyce! Nice to meet you. What's your last name?
    wight
  • Let's get a face to your name Alyce.
    FEA0D3E8_3DA5_4792_A766_CDC101ADEDE2.jpeg
  • Thanks for the great pic Alyce. What is your email address?
    wateva@gmail.com
  • We also require your best contact number.
    +65656266
  • What is your date of birth Alyce?
    25/08/1987
  • And can you give us your complete address with postcode please?
    23 gehteith
  • How did you hear about us Alyce?
    Website
  • What is your instagram account?
    In the process of creating one
  • What is your current occupationAlyce?
    As of today, finished work so I’ll be moving to Sydney to find work again
  • Do you have any experience working in the cosmetic tattoo industry?
    No
  • That's all the details we require Alyce. Now its time to seal the deal with a deposit. 
    Bank Account


To this what seems like a big mess to me.

Your typeform Permanent Make-up Course has a new response:

  • For which course are you registering?
    Eyelash Extension
  • We're excited to have you on board. 
    What's your first name, please?

    Yuri
  • Your course is Eyelash Extension.
    Excellent choice Yuri!
    Registering for another course in this application, will qualify you for a 'combined course discount'.

    Teeth Whitening
  • Yay, Well done!
    You've committed to furthering your knowledge with 2 courses booked.
    But maybe you're thinking of another course?
    Let's take a final look at the courses you chose again.
    Eyelash Extension
    Teeth Whitening
    Courses Total: A$2255
    Deposit Total: 0
    We are at the last chance to register for another class at a continued discounted rate.

    No More Courses Thanks!
  • What's your last name Yuri ?
    erwetewt
  • We also require your best contact number.
    +6463164
  • What is your date of birth Yuri ?
    20/08/19565783
  • And can you give us your complete address with postcode, please?
    2099
  • How did you hear about us?
    Friend Referral
  • What is your instagram account?
    ABC
  • What is your current occupation Yuri[Not asked][Not asked]?
    Beatician
  • Do you have any experience working in the cosmetic tattoo industry?
    Yes
  • That's all the details we require Yuri[Not asked][Not asked]. 
    Now it's time to seal the deal with a deposit. 

    Bank Account
  • course_cost
    2255
  • coursecount
    2
  • eyelash
    1595
  • microblading
    3850
  • ombre
    1100
  • ombre_lip_eye_hair_pen
    1980
  • Score
    0
  • smp
    3300
  • stripe
    0.98
  • subtotal_deposit
    0
  • teeth
    660
  • yesno_eyelash
    Eyelash Extension
  • yesno_eyeliner
    No
  • yesno_hairline
    No
  • yesno_lip
    No
  • yesno_micro
    No
  • yesno_ombre
    No
  • yesno_ombre_addon
    No
  • yesno_pen
    No
  • yesno_smp
    No
  • yesno_teeth
    Teeth Whitening
Userlevel 7
Badge +5

Hi @TFJunkie When you choose the option to “add all” questions in the notifications, seeing the variables in the notifications is expected behavior. To avoid this, you will need to add each question individually. 

Userlevel 3
Badge +2

Hi @TFJunkie When you choose the option to “add all” questions in the notifications, seeing the variables in the notifications is expected behavior. To avoid this, you will need to add each question individually. 

I’ve read that response in another thread. I don't understand the answer and I don't remember choosing to add all questions. What do you mean, ‘add each question individually’?

Userlevel 7
Badge +5

Hi @TFJunkie If you choose the option to add all the answers, it will include both the answers to all questions and the data from the variables. 

If you want to only include some questions, you can click the + button shown below to add individual questions. 

I hope this helps clarify! 

Reply