Dynamically insert date based on day of submission | Community
Skip to main content
Answered

Dynamically insert date based on day of submission


Im looking for a way to insert a variable in submission notifications. 

Specifically looking to insert name of 3 months prior to month submission was completed… for example 

  • User submits form in April
  • In notification I’d like to be able to insert (January, February, March)

Like so…

“….please be sure to send us GA reports for January, February and March.

 

OR

 

  • User submits form in December
  • In notification I’d like to be able to insert (September, October, November)

Like so…

“….please be sure to send us GA reports for September, October and November

Best answer by john.desborough

@Desto - one way of doing this would be to create a variable to hold the months text and then use the logic rules to populate the string

variable: v_result is what i used in the image below

use logic rules to set the value of the text variable 

and then use the @recall feature to recall the variable into subsequent pages. the variable would be stored as part of the submission data

just one approach

 

des

View original

5 replies

john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5328 replies
  • Answer
  • April 12, 2023

@Desto - one way of doing this would be to create a variable to hold the months text and then use the logic rules to populate the string

variable: v_result is what i used in the image below

use logic rules to set the value of the text variable 

and then use the @recall feature to recall the variable into subsequent pages. the variable would be stored as part of the submission data

just one approach

 

des


  • Author
  • 3 replies
  • April 12, 2023

@john.desborough thanks for chiming in here… 

if I understand this correctly id just need to create 12 if/then conditions - 1 for each month? 


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5328 replies
  • April 12, 2023

@Desto - that would be the progression of what i was suggesting in the images above, yes.. 

 


  • Author
  • 3 replies
  • April 12, 2023

I’ll give that a shot. Thanks!


  • Author
  • 3 replies
  • April 24, 2023

Hi again. Im afraid I am not able to get it working. Is there a way to identify which month is current dynamically? Meaning, I logic above is based on assumption I know which month it is at the time of submission. How can I get that information into the form so I can applied variable correctly? 


Reply