Typeform and Trello - Help with excluding data please | Community
Skip to main content
Answered

Typeform and Trello - Help with excluding data please


Hello!

I have integrated a Typeform to a Trello board - every response gets pulled through to a Trello board as a card.

The Typeform is asking for the persons email address, pet name, and a photo of their pet.

This will then be pulled through to the Trello board, where 120+ volunteers will see the responses and draw pet portraits from the photos (we are an animal charity - it's a fundraising campaign).

 

ISSUE: For privacy issues, we can't have the volunteers see the email addresses pulled through from the form - just the pet photo, and pet name. 

 

Is there any workaround for this? 

I have included a very technical screenshot.

If anyone could help I will personally build a monument in your name.

JB

 

Best answer by john.desborough

@josie_2817 - welcome to the community. 

one possible ‘work around’ is to split the typeform into two separate typeforms that are connected by a redirect on completion (and a connection Google sheets where you could capture the email but not send it to trello.. here’s what i am thinking:

  • form one - has the pet name and file up load questions 
    • you use the redirect upon completion setting to send it to the form that contains the email question and add the petname and fileup load details as hidden fields (not absolutely sure that you CAN add a file upload detail ie the file itself but you should be able to capture the name of the file - need @mathio or @picsoung @Liz or @Gabi Amaral  to weigh on that) 
    • change the ‘message text’ from Submit to ‘One last thing to add’ so that the user doesn’t think they are being passed from one form to another
    • this form is connected to the Trello board 
  • form two - has the email question and the hidden fields from the other form
    • create the hidden fields in the Variables section of the logic so that you have the receptor fields
    • have one field in this form for the email address for contact purposes
    • connect this form to Google Sheets so that the output has gone into something where you collect the email address along with the petname and file details. 

This is not a perfect solution if you have workflow built into Trello that would now require you to do something with the Google Sheet. BUT it does capture the email into a usable file for you and keep it out of the Trello board. 

 

just a thought.. 

 

des

View original

6 replies

john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5275 replies
  • Answer
  • January 13, 2022

@josie_2817 - welcome to the community. 

one possible ‘work around’ is to split the typeform into two separate typeforms that are connected by a redirect on completion (and a connection Google sheets where you could capture the email but not send it to trello.. here’s what i am thinking:

  • form one - has the pet name and file up load questions 
    • you use the redirect upon completion setting to send it to the form that contains the email question and add the petname and fileup load details as hidden fields (not absolutely sure that you CAN add a file upload detail ie the file itself but you should be able to capture the name of the file - need @mathio or @picsoung @Liz or @Gabi Amaral  to weigh on that) 
    • change the ‘message text’ from Submit to ‘One last thing to add’ so that the user doesn’t think they are being passed from one form to another
    • this form is connected to the Trello board 
  • form two - has the email question and the hidden fields from the other form
    • create the hidden fields in the Variables section of the logic so that you have the receptor fields
    • have one field in this form for the email address for contact purposes
    • connect this form to Google Sheets so that the output has gone into something where you collect the email address along with the petname and file details. 

This is not a perfect solution if you have workflow built into Trello that would now require you to do something with the Google Sheet. BUT it does capture the email into a usable file for you and keep it out of the Trello board. 

 

just a thought.. 

 

des


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14919 replies
  • January 13, 2022

@josie_2817 The file upload will come through as a URL, in which you’ll need to be logged into the Typeform account to view the file. Hopefully that clears things up!


  • Author
  • Explorer
  • 2 replies
  • January 17, 2022

@john.desborough This works. I can confirm I will be building a monument in your name. THANK YOU SO MUCH!!!!! :grinning::dog::cat:


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5275 replies
  • January 17, 2022

@josie_2817 - buy someone a coffee and pay it forward lol.. much better than a monument in my name.. 

glad it worked for you!

 

des


  • Author
  • Explorer
  • 2 replies
  • January 18, 2022

@john.desborough  will do. Thank you again! :blush:


Gabi Amaral
Ex–Typefomer
Forum|alt.badge.img+5
  • Ex–Typefomer
  • 1777 replies
  • January 18, 2022

​​​​Hey @josie_2817! Hope you're having a good day. I'm glad John were able to help you! 

Make sure to share with us your typeform, I'm curious to see how it is! 

All the best! :wink:


Reply