Creating a unique RMA number. | Community
Skip to main content
Answered

Creating a unique RMA number.

  • October 17, 2022
  • 5 replies
  • 324 views

Hello, I am looking to see if there’s a way that I can create a form that once complete (and depending on conditional logic), emails a unique RMA to the customer. 

This RMA (Return Merchandise Authorization) will be used by the customer to affix to their package, so that when we get it back at our office, we can cross reference the code with the customer filled content form.

I feel like there MIGHT be a way here but I have not spent enough time looking. Currently, I can get JotForm to do this but, it’s ugly and doesn’t really function well on my site.

Thanks a bunch. 

    

Best answer by john.desborough

@The_Islands - not the most elegant work around but.. 

  • you could connect the typeform to a google sheet
  • in the google sheet you could generate a random number string whenever a new record is added 
  • using an add-in called Document Studio  you could create the email from the Google Sheet  that sends the user the email with the RMA (random string field) as part of the email body. 

just a thought

 

des

 

View original

5 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14960 replies
  • October 18, 2022

Hi @The_Islands Welcome to the community! Happy to have you here. The post below has a similar solution to what you’re looking for: 
 

 


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

Thanks for the reply. But, it would seem that the promo codes need to be already created in order for them to be used. I was hoping that there was a way for TypeForm to generate a random number in which I can associate to the product they’re sending back, to the form they just filled out.

 


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5296 replies
  • Answer
  • October 18, 2022

@The_Islands - not the most elegant work around but.. 

  • you could connect the typeform to a google sheet
  • in the google sheet you could generate a random number string whenever a new record is added 
  • using an add-in called Document Studio  you could create the email from the Google Sheet  that sends the user the email with the RMA (random string field) as part of the email body. 

just a thought

 

des

 


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

Thanks for chiming in @john.desborough 

Ill give that a try - have a great day! 

 

-G


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14960 replies
  • October 19, 2022

Let us know how it goes, @The_Islands !


Reply