Spreadsheet Widget: Add an Add Button

  • innovation.authority
    Asked on May 26, 2022 at 7:06 PM
    How to control each column with separately in "input table" and in spreadsheet?
  • Afzal JotForm Support
    Replied on May 26, 2022 at 7:12 PM

    Thank you for your patience, Ofer. My apologies as I was not able to understand your query correctly. Are you looking to control the columns in the input table field and the spreadsheet field using a conditional statement or looking to control the text alignment using CSS code?

    Once we have a better idea, we’ll be able to come up with a solution.

  • innovation.authority
    Replied on May 27, 2022 at 8:20 PM

    Hello ,

    Thanks for your answers regarding the RTL issue in Spreadsheet widget. it works fine.

    My second question is regarding the control of the column width in "Input Table" and "Spreadsheet " widgets. I would like to control each column width separately.

    You can see the issue in my test's forms:

    https://www.jotform.com/build/221463915397463

    https://www.jotform.com/build/221464522416450

    I have some more issues:

    1. In the Text editor, How to limit :
    2. text length.
    3. number of the lines.
    4. words count
    5. How to control the distance/lines-space between form elements mainly "Header" and "Paragraph".
      They take a lot of space between the elements.
    6. How to control the Hight of the "Header" and " Paragraph"
    7. How to control the space between lines in "Header" and "Paragraph" elements/Properties.

     Thanks

    Ofer


  • Elaine_G
    Replied on May 28, 2022 at 12:25 AM

    Hi,

    In order to achieve your requirements, please inject the following CSS code:

    .form-matrix-column_0 {
    width10px !important;
    }


    You can add character limits on a short text field on its properties:

    1653711912 6291a42836071  Screenshot 10

    You can change the form layout on the advanced designer.

    1653711879 6291a407df713  Screenshot 21

    Hope this information can be of help to you. Please do not hesitate to reach us at any time if you need further assistance.

    Thanks for choosing Jotform!

  • innovation.authority
    Replied on May 28, 2022 at 12:33 PM

    Hello,

    The "line spacing" is not working as expected.

    In form:

    See configuration and outcome regarding line spacing in the " Paragraph".

    1653732590 6291f4ee3dde1 line spacing Screenshot 10

    The line spacing in the " Paragraph" is not as expected.

    See configuration and outcome regarding line spacing in the ""Header"

    1653732885 6291f615cd0de Head spacing Screenshot 21

    The Vertical Margin and the Vertical Padding at the Headers are not as expected.

    Regarding character and line # limitation:

    I Know how to limit the number of characters in the "TextArea Autosize " and "Character Counter" widgets. My question relates to How to limiting the number of lines in editor widgets like "Squire Editor", "long Test Properties", "CKEditor" or any other editor that allows "RICH TEXT".


    Regarding my question about the Spreadsheet see my tests in https://www.jotform.com/build/221463915397463

    I tested the CSS code and it did not work as you can see.

    .form-matrix-column_0 {
    width10px !important;
    }

    I only can change Column width by adding fictitious characters to the Column labels. How can I add spaces instead?

    1653752977 62924491de91d spreadsheet wid Screenshot 32

    Do you have another code that can help me change the Column width? The code you gave me does not work.

    How can I add a Button for adding lines to the spreadsheet as you have in the infinity widget?

    I am testing your product for a large project that will require many flexible and advanced features.
    I guess I will have some more questions regarding the use of your products.
    I appreciate your help up to now and in the future.

    Thanks for your help.

    Best regards

    Ofer




    "


  • Gilbert JotForm Support
    Replied on May 28, 2022 at 1:59 PM

    Hello Ofer,

    Regarding your inquiry on how to adjust the column width of the Spreadsheet widget, please delete the additional dummy text you added in the Column Labels and add these codes to the custom CSS tab of the widget.

    .A {
    width: 150px;
    }


    This should adjust the width of column A:

    1653760046 6292602e83a7f  Screenshot 10

    If you want to adjust the width of the next column, you can use this code:

    .B {
    width: 20px;
    }


    Just change the letter after the dot(.) to the consequent letters(C, D, E, etc.) if you want to switch to the other columns. Then, change the value of the width property according to your liking.

    As for your other concerns, I moved them to different threads so we can address each of them separately. We aim to focus on a specific issue or concern per thread to avoid confusion and to keep it organized.

    We'll get back to you on each of those threads shortly. If you have further questions, please post them on the respective threads.

  • innovation.authority
    Replied on May 29, 2022 at 4:26 AM

    Hello,

    Regarding the spreadsheet, the code works only after the deletion of the fictitious characters in the field name.

    What about the my second question regarding the spreadsheet?

    How can I add a Button for adding lines to the spreadsheet as you have in the infinity widget?

    Thanks

    Ofer

  • Norwyn JotForm Support
    Replied on May 29, 2022 at 4:53 AM

    Hi innovation.authority,

    Thanks for reaching out to Jotform Support. Unfortunately, the feature you're looking for isn't available at Jotform right now. We've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

    Thanks for your patience and understanding, we appreciate it.