How to allow to enter a 3 digit code to a table?

  • joyallisonzt
    Asked on October 26, 2016 at 10:33 AM

    I need the table in this form to be able to allow the user to put in up to a 3-digit number in each field indicating how many volunteers they will have for each shift.

    I also need to disable the 2pm-6pm (Wed only) boxes under the Monday & Tuesday fields.  This shift is ONLY available on Wednesday, so how do I grey-out or mask those two number fields?

    And if I am using the wrong widget to allow users to insert a 3-digit number, what form or widget should I use, I could not find any samples.

    https://www.jotform.com//?formID=62990760838166

     

    joy

  • Kiran Support Team Lead
    Replied on October 26, 2016 at 1:27 PM

    The MultiSelect Grid widget that is being used in the form doesn't allow to enter any text into the boxes. Since you want to enter some text into the column boxes, you may consider using Matrix field from the Survey fields.

    How to allow to enter a 3 digit code to a table? Image 1 Screenshot 40

    The matrix field allows to enter a variety of input types and you may choose the required from the drop down.

    How to allow to enter a 3 digit code to a table? Image 2 Screenshot 51

    Though it is not possible to disable the input into the fields directly, you may inject the following CSS code to disable mouse event on the selected input fields.

    #input_29_0_3, #input_29_1_3 {

        pointer-events: none;

        background:#F5F5F5;

    }

    How to allow to enter a 3 digit code to a table? Image 3 Screenshot 62

    User would be able to enter information to the mouse events disabled fields by using the tab key on the keyboard.

    If you want to disable the input field completely, it may be achieved by getting the full source code of the form.

    Hope this information helps! 

  • Kiran Support Team Lead
    Replied on October 26, 2016 at 1:29 PM

    Please take a look at the cloned version of your JotForm with the above changes.

    https://form.jotform.com/62995551480970

    Please feel free to clone it to your account. Thank you! 

  • joyallisonzt
    Replied on October 26, 2016 at 8:44 PM
    Thank you! Using the CLONE option was brilliant & I am all set on the form.
    THANK YOU!
    May I ask, since I need all the results in a spreadsheet, which I have
    already create:
    *Volunteer Spreadsheet Link:*
    https://docs.google.com/spreadsheet/ccc?key=1gy9vpkAp2gtG-oIlUITZKNgY_
    627nu-CeAP_yjazjI0
    Can I edit the headers of the spreadsheet so the content can be seen in a
    more consolidated space? In other words, the present header fields are SO
    LONG, they run off the page, for example "Please fill in how many
    volunteers you have for each shift. >> Monday 11/21 >> 2pm to 6pm (Wed
    ...
  • Rose
    Replied on October 27, 2016 at 2:31 AM

    I did not open the spreadsheets you provided above. However, If I understood you correctly, you would like to change the column header on your spreadsheet. 

    Please note that the column header on your spreadsheet are the names of the fields on your form. If you try to change name of a column header on your spreadsheet, there is no guarantee that the integration can works properly after the change. Furthermore, any update done on your form is reflected to the google spreadsheet. 

    When I checked earlier thread about the same issue; there has been already a feature request. On the other hand, this ticket is still open and I can not promise you that it will be implemented soon. If there will be any update for this feature, you will be notified via this thread. 

    If you have more questions, please feel free to contact us.