Autopopulate the month/year

  • Profile Image
    PracMed_NZ
    Asked on January 04, 2022 at 08:20 PM

    Hi Team,

    We have forms that need to mark just the year and the month it was submitted to trigger an action in Activecampaign (the month/year will be a tag that triggers an automation). We already have a hidden date picker which generates the full date (which we need for another report). My thought was to add a hidden DatePicker year month widget - just wondering how I set that up so it auto populates with the current date/month of submission.


    Thanks! :)

    Steph

  • Profile Image
    sweta_s
    Answered on January 05, 2022 at 02:47 AM

    Greetings Steph!

    You can extract the month and date from the Date Picker element using a Substring widget:

    1641368821_61d54cf52b252_

    Please go through the Demo form link:

    https://form.jotform.com/220040950319951

    Should you have any further queries, please let us know.

    Thanks.

  • Profile Image
    PracMed_NZ
    Answered on January 05, 2022 at 08:05 PM

    Thanks for the reply - I can't seem to get it to work.

    I have {date} as the field ID1641431051_61d6400bef1e1_Screen Shot 2021641431096_61d6403899217_Screen Shot 202

    but nothing is populating when I do test runs. This is how it looks, there is nothing under it.

    1641431137_61d640613e9da_Screen Shot 202


    Thanks for your help! :)

  • Profile Image
    sweta_s
    Answered on January 05, 2022 at 09:44 PM

    You need to write the Field ID and not the unique name.

    You can get the Field Id this way:

    1641437062_61d657866f557_

    Thanks.