Creating spreadsheet layout with dropdowns

  • Navassa
    Asked on March 12, 2015 at 12:45 PM

    The answer you provided graciously and appreciated here, but, just not get me to where i need to be. perhaps my communication is poor.

    I need this form with all the grids and boxed as shown, etc,...just like you see here. etc.   I know how to change the submit, thank you, etc.

    If I'm asking too much, I understand, but need to know. 

    it would be NIFTY/cool if within the cell I could use drop downs for some of them....if not, I understand.   Thank you

    So...if possible.  I'd like a drop down  in each blank BAND cell for the following selection:  6m, 10m, 12m, 15m, 17m, 20m, 30m, 40m, 60m, 80m, 160m

    ANd in each blank MODE CELL, the following selection choices:  CW, SSB, RTTY

     

    Possible?  Thank you.   Randy   ....  

     

                     
      CALLSIGN DAY MONTH YEAR UTC BAND MODE  
      FS/AA4VK              
                     
                     
                     
      FS/N0TG              
                     
                     
                     
                     
            SUBMIT        
                     
                     
                     

     

  • Ben
    Replied on March 12, 2015 at 2:00 PM

    I see that you are looking to achieve something similar to this:

    Creating spreadsheet layout with dropdowns Image 1 Screenshot 20

    Now both forms in your account are empty (I would actually suggest to remove such forms from your account).

    Now I also believe that this is related to my response here: http://www.jotform.com/answers/531247

    If so I would like to ask you to always reply to the same thread since that will allow us to provide you with concrete answers and help you set it all up properly. For example, this (current) thread can be seen here: http://www.jotform.com/answers/531926

    Can you please tell us if by the layout you mean that you would like to have the lines shown as on the image - around each field or if you have any reference to link to so that we can check it out and understand what you would like the end result to look like?

    If it is just like the image above, but with dropdowns in Band column, than we could work out some CSS code that would place the dropdowns 'into' the cell.

  • Navassa
    Replied on March 12, 2015 at 3:12 PM

    It needs to look like EXCEL with the nice single line cells.  I've tried to paste a copy of the EXAMPLE prepared in EXCEL below, i.e., if the image/format HOLDs together when sent to you.

    The size below is about right.  

    I would like a dropdown for appropriate blank cells under BAND, MODE Cells per previous data submitted.

    And, if this is all possible, then rather than list the TWO CALL Signs....make a DROP DOWN  for cells under CALLSIGN as well for the selection rather than for it to be a static.    If the Format doesn't seem to come over to you, perhaps I could copy to WORD and send via email for you to see what I am talking about. 

    Thank you for you patience....hope not to be too much of a pest.

    Randy

     

    CALLSIGN

    DAY

    MONTH

    YEAR

    UTC

    BAND

    MODE

    FS/AA4VK

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    FS/N0TG

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

             

     

     

       

    SUBMIT

       

     

     

     

     

     

     

     

     

     

  • Navassa
    Replied on March 12, 2015 at 3:14 PM

    Bummer....I can see now after I replied that he Spreadsheet format did not hold together.

    If you have an email and permitted for me to send, I can do that as an attachment in WORD.

  • Ben
    Replied on March 12, 2015 at 4:20 PM

    I would actually suggest sending us the screenshot instead Randy. That way we would be able to see it just as you do since for example, I am using Google Spreadsheet or LibreOffice Calc and often the things do not look quite the same as Excel file.

    You can see how to do that by following these steps: How to add screenshots/images to questions in support forum?

  • Navassa
    Replied on March 12, 2015 at 6:02 PM

     

  • Navassa
    Replied on March 12, 2015 at 6:04 PM

    tried to add.   Can't figure it out;   guess I will have to give up.

    Just don't understand, though,  all I want is a spread sheet with certain coulumn with a dropbox.  I've defined the columns.   Oh well ,   tnx for trying.

  • Ben
    Replied on March 12, 2015 at 6:21 PM

    The reason why I was asking more questions because, while it did not look like the Excel or any other spreadsheet, the Configurable List would allow you to add the dropdowns and keep everything in a similar layout.

    When you go to the page above, you will be able to see its demo and you can see here how to add it to your jotforms: How to Add a Widget to your Form

    Would that work for what you are looking to achieve?

  • Navassa
    Replied on March 12, 2015 at 7:10 PM

    Too complicated.

    I need the simple GRid like EXCEL and put a few dropbox's in it.

    I give up.

    thanks for you time

  • Kiran Support Team Lead
    Replied on March 12, 2015 at 9:53 PM

    Hello Randy,

    Using Configurable list is easy and we believe that your requirement can be achieved by using this widget. I've tried working out on your requirement using the configurable list. Please see the demo below and let us know if that works for you.

    http://form.jotformpro.com/form/50708368278970?

    Using this widget, you can add a number of rows by default and can also restrict to a maximum number of rows that you need. 

    Please feel free to clone this JotForm to your account by following the instructions provided in the guide below for making any modifications as you need.

    http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Thank you!

  • Navassa
    Replied on March 12, 2015 at 10:16 PM

    Hello Kiran:

    ah.....my hero!!!   Thank you, and yet I can use this.   I imported already into my website;  no problems.

    Now, question:  The TEXT at the top..."Configurable List", does that have to stay?  I think it could confuse the user.

     

    Next, I plan to use this form on several pages.  Each page will Need a Different DROP DOWN for the first colum  (CallSign).   Can I change that myself , behind the scenes?

     

    Also,

    some of the page forms on other pages will need to be sent to different email.   Can I change that behind the scenes?

    Thanks, good job and thanks to the other folks as we moved step by step to get to this.  Thank you.

    Randy

  • Kiran Support Team Lead
    Replied on March 12, 2015 at 11:16 PM

    We are glad that we could help you. It's our pleasure to assist you.

    The text "Configurable list" can be changed as per your requirement on your JotForm just by clicking on it. Also, the first column of the widget can be changed from the widget wizard. Please see the recorded session below that can help you with this.

     

    Creating spreadsheet layout with dropdowns Image 1 Screenshot 20

    Since you need different options in the dropdown for different pages, you may need to create multiple forms by cloning the same form for each page. 

    Hope this information helps. Please do not hesitate to get back to us if you need any further assistance. We will be happy to help.

    Your question on email setup is moved to a separate thread mentioned below to avoid confusions discussing multiple issues on a single thread.

    http://www.jotform.com/answers/532375

    Thank you!