I need to be able to take pieces of data from fields like "Name" & "Date+Time"

  • Profile Image
    securenetwork
    Asked on January 16, 2017 at 03:58 PM

    Hello,

    I am using the data from 2 fields to create a username which I provide to the person filling out the form. I need to be able to take pieces of data from fields like "Name" & "Date+Time" and create a pre-calculated field of "Last Name+Time". My question is what do I need to put into the condition of calculating a field to pull the data I need to create the data for the new field?

     

    Thanks

  • Profile Image
    BDAVID
    Answered on January 16, 2017 at 08:51 PM

    We do not have a conditional logic that would pull certain characters from a field, however, you could use the Substring widget which is meant for this purpose: https://widgets.jotform.com/widget/substring 

    However, it will not work with date type fields. So, I am guessing you could convert the date to string value using a Form Calculation widget: https://widgets.jotform.com/widget/calculation 

    https://www.jotform.com/help/252-How-to-Add-a-Widget-to-your-Form 

    Let us know if you need more help.