Can we adjust the delivery date based on the city selected on our form?

  • Mds2123
    Asked on November 16, 2015 at 1:55 PM
    I know want to add various Cities to my form.  I want people to be able to choose from Austin, Houston, San Antonio, or Dallas.  Depending on what city select, they will only be able to chose certain days for delivery.

     

    For example:  

    If they select Houston:  The only deliver dates are 11/19 and 11/20

    If they select Austin:  Only delivery dates are 11/17 and 11/18, etc.

     

    Can this be done? 

     

    Thank you

  • Ben
    Replied on November 16, 2015 at 2:02 PM

    Can you please tell us a bit more details since the previous thread contained several different subjects and I see that you have additional threads as well.

    The detail that I am asking about is to check if you want your user to enter the address into the Address field, and based on that value to determine the date of delivery?

    Or do you want to have a specific field for several different towns / cities of choice - to which you deliver?

  • Mds2123
    Replied on November 16, 2015 at 4:19 PM

    Hi Ben,

     

    Yes I will try my best.  Good question.  I want the address field to be there regardless.  I have sense added a dropdown menu for city.

    -Austin

    -Dallas

    -Houston

    -San Antonio

     

    Based on their selection of the city, I want certain dates to show up.  For example, if they select austin I only want Thursday to be a delivery option.  If they select san antonio I only want friday to be a delivery option, if they select Houston I only want Saturday to be a delivery option, if they select Dallas I only want sunday to be an option.  This the general idea.  I can decide exact dates later.

     

    Can this be done?  I know it's repetitive sense they are adding the city in the address field, but I'm not sure how else this can be done.

     

    Thanks,

     

    Mike

  • Ben
    Replied on November 16, 2015 at 5:56 PM

    This would be the easiest way to do it Mike, that is why I asked for more details :)

    With the dropdown, this allows us to not need to touch the payment tools, but just use the data that we need.

    Now based on what you have said, there are 2 ways to do this.

    1st - completely through conditions and passing the field value to the Text Element

    2nd - using the form calculation and few condtions

    Now I think that the Form Calculation is much better option since it allows you more freedom during the setup of this and with a bit of CSS we can make it look just as we want.

    Now I made a quick demo form for you to check out: https://form.jotform.com/53197043875968

    The steps however are similar no matter what is the form, so let me go through them.

    1. Add a dropdown to your form (you did this)

    2. Add cities to the dropdown options (you did this as well)

    3. Set the calculation values to represent the days that you wish to have each city show.

     You can see more about this here: How to Assign Calculation Value

     I set it up like this:

     Can we adjust the delivery date based on the city selected on our form? Image 1 Screenshot 70

    * You have probably noticed the N/A at the top - we need to add something for the empty option shown by default in the dropdowns and we will add the condition that will make it not shown at any time, so it does not matter what it is (but can not be space or empty row).

    4. Add Form Calculation to your form

     You can see how to add a widget to your form here: How to Add a Widget to your Form

    5. Set the Form Calculation widget to show the custom text and the day that we set in the step 3. This is how I set it up:

    Can we adjust the delivery date based on the city selected on our form? Image 2 Screenshot 81

    Now when you first add the field to the Form Calculation widget, it is set to capture the number value (orange color), but we need it to pass text in our case, so all we do is to click the numbers in the top right corner. This quick screen cap shows this for you:

    Can we adjust the delivery date based on the city selected on our form? Image 3 Screenshot 92

    Once it is black - we have it just as we want it and we can close the Form Calculation wizard.

    6. Add a Text field to your form

    7. Set the text in it to show the message that you want to show to your users

    Can we adjust the delivery date based on the city selected on our form? Image 4 Screenshot 103

     Once you add the text just hit that green OK.

    8. Set condtions

     To show the message about selecting the city and in the same time hiding the form calculation I made this setup:

    Can we adjust the delivery date based on the city selected on our form? Image 5 Screenshot 114

    Now to add additional style to it I added a condition to submit button if the city is not selected:

    Can we adjust the delivery date based on the city selected on our form? Image 6 Screenshot 125

    Now that is it.

    There is just the custom CSS part that I added to make the form calculation listen to what we need ;)

    #label_3 {
        display: none;
    }
    #id_3 > div {
        width: 100%;
    }
    #input_3 {
        border: medium none;
        box-shadow: none;
        width: 100%;
    }
    #stage #label_3 {
        display: block;
    }

    This is however specific to the form, so if you are going to add the steps above to your form, just let us know once you add the form calculation and we will help you with the CSS for it :)

  • Mds2123
    Replied on November 16, 2015 at 11:47 PM

    Hi Ben,

     

    In all honesty I don't really have time to learn this.  Can I pay you to help me or something?  This is more or less going to be a one time thing so I am focusing my efforts on other aspects of the business.  Also, this is pretty much the last thing I want to add to my form.

     

    Here is exactly what I want:

    If Austin is selected, I want the following dates to be options:  Thursday 11/19, 11/26, 12/3, 12/10, 10/17, 12/31

    For Dallas:  Saturday 11/28, 12/5, 12/12, 12/19, 

    For Houston:  Friday 11/20, 11/27, 12/4, 12/11, 12/18

    For San Antonio:  exact same as Austin

    I would greatly appreciate it if you can help me out this this.  Normally I would figure it out myself but I am very strapped for time.

    Thank you,

     

    Mike

  • Elton Support Team Lead
    Replied on November 17, 2015 at 8:04 AM

    Hello Mike,

    I checked your current form setup and I see two drop down fields labeled "City" and "Delivery Date". As of this time, we do not have any feature that removes or disable the drop down field options base on the selected value from another field. However, there's an available workaround for that using the show/hide condition as also suggested by my colleague. However, this time I suggest to use DateTime field (under Quick Tools) so it is easy for your users to pick a date with a limit of course and so you will not update the dates on the dropdown field manually as the days goes by.

    So basically, you need to add 3 different DateTime fields in your form. Example:

    Can we adjust the delivery date based on the city selected on our form? Image 1 Screenshot 30

    Then open the properties on each of these date fields (Right click > Edit Properties) then set its calendar limit to only allow specific days to be selected.

    Example, if you want the date field to allow only Thursday date to be selected, then uncheck everything on the Days of the week except Thursday like this. You need to do the same for the other date fields then uncheck which days you want to disable.

    Can we adjust the delivery date based on the city selected on our form? Image 2 Screenshot 41

    Then start creating the Show/Hide conditions,

    Example:

    If City is Equal To Austin, Show Delivery dates with only Thursday enabled.

    Here's a clone of your form which I have these applied https://form.jotform.com/53203403057948?. Feel free to clone this form and use it if you like.

    Hope this helps. Thanks!

  • Mds2123
    Replied on November 17, 2015 at 9:58 AM

    I don't have check boxes on mine.Can we adjust the delivery date based on the city selected on our form? Image 1 Screenshot 20

  • Ben
    Replied on November 17, 2015 at 11:08 AM

    I apologize Mike, but I am not quite sure what you mean by checkboxes?

    I took a look at the form made by my colleague above: https://form.jotform.com/53203403057948 and I see dropdown to select the city and DateTime widgets as mentioned in his reply, but no checkboxes that you are referencing.

    Please do try to clone it again to your account by following these steps: How to Clone an Existing Form from a URL

    Do let us know how it goes.

  • Mds2123
    Replied on November 17, 2015 at 11:59 AM

    Ok I see what you mean.  I don't want to clone the entire form though, just the portion for the city and delivery date like we are discussing.  How can I do this?

     

     

  • Mds2123
    Replied on November 17, 2015 at 12:20 PM

    Better yet, can you put the city/date info we are discussing in my form called "Social Ice?"  That would be much easier and better for me.

  • jonathan
    Replied on November 17, 2015 at 3:41 PM

    I am doing the transformation for you.  I will update this shortly when done.

    Thanks.

  • jonathan
    Replied on November 17, 2015 at 3:55 PM

    I have made the changes needed to your jotform https://form.jotform.com/53056493768164?

    Can we adjust the delivery date based on the city selected on our form? Image 1 Screenshot 30

    Since it has an existing submission that uses the 'Delivery Date', I cannot remove the field. So I had it hidden from the form so that the submission data will not be deleted.

    I have added the Conditions needed so that the form will use the newly added specific Delivery Dates base on 'City' selected option.

    Can we adjust the delivery date based on the city selected on our form? Image 2 Screenshot 41

    Hope this help. Let us know if you need further assistance.

  • Mds2123
    Replied on November 17, 2015 at 8:10 PM

    Thank you for your help.

     

    Mike

  • jonathan
    Replied on November 17, 2015 at 10:19 PM

    You are quite welcome. 

    Contact us again anytime for any assistance you need on JotForm

    Cheers