I'm hoping to set up a web based scheduling form for my department.

  • Profile Image
    Asked on May 23, 2011 at 11:43 AM

    I'm hoping to set up a web based scheduling form for my department. when shifts are taken they will "disapear" from the inventory of available shifts. I.e a given drop down list has 5 nights available and when one of then is taken and the form is submitted, the next time that drop down is used it will have one less night to choose from.


    hope thats clear as mud for you!





  • Profile Image
    Answered on May 23, 2011 at 12:16 PM


    As functional as your idea sounds, Jotform does not have the capability to accomplish this, yet. Form field values cannot be dynamic. These values cannot change unless you modify them manually.

    There is a workaround I could think of that might mimic the workflow that you want to implement in your form. Take a look at this sample form to see what I mean. Let me know what you think of it. If you need assistance with creating such a form, do not hesitate to ask.

    I'll be awaiting your response. Thank you.


  • Profile Image
    Answered on May 23, 2011 at 12:26 PM

    Hi Jason

    It's quite clear indeed (not clear as mud but really clear :)

    Unfortunately, if my memory serves me correctly, it is not currently possible to do that with our forms. Perhaps one of my colleagues might be able to come up with a workaround of some sort though.

    I think a request for this feature was already submitted but I'll put it in again just to be sure.

    Thanks for asking.


    ~ Wayne

    EDIT: Yep, see what I mean about one of my colleagues possibly coming up with a workaround? LOL

  • Profile Image
    Answered on May 23, 2011 at 01:38 PM

    Thanks for the fast replys! I'm pretty excited that I found Jotform. I can see that it has huge potential and I'm sure that there is a way that I can make this work even if the feilds are not dynamic (yet).

    If I go with a simple spreadsheet/matrix type of master schedule and use text boxes then the individuals can replace the default text with their initials if they choose that shift. My question is that when they press the submit button and the next person goes to enter their shifts; are the previous changes reflected on the master sheet or does the sheet/matrix revert to its default values again?

  • Profile Image
    Answered on May 23, 2011 at 02:10 PM

    Now it's getting a little muddy :)

    I apologize if it confused you, but this thing right here:

    is not a form "field", per se. It is actually an html table report embedded inside the form using a Free Text HTML tool. The information displayed on that report reflects the submissions entered in that exact form. Those cannot be changed unless the entries are edited by you or the person who have submitted the entry.

    Again, it is not a sheet or matrix. It is just an html table report. For more information about html table reports, refer to this slightly similar issue.

    Let me know if you require further assistance. Thank you.