Spreadsheet to Form widget issues

  • Profile Image
    Zbulo
    Asked on January 06, 2022 at 05:54 AM

    Hello Jotform team,

    The widget doesn't load function / load whenIt's not located on the same page / placed after the page break.
    It's hiddenWhen the form is opened, the widget is shown for a short time before it vanishes.

    1641466345_61d6c9e9343b0_

  • Profile Image
    Richie_P
    Answered on January 06, 2022 at 07:45 AM

    I did check your form and it seems you're using conditions to fill the spreadsheet to form widget based on the data on another field.

    The widget is shown in a short period could be due to conflict of conditions in the form.

    Can you please share the flow of your form ?

    Looking forward for your response.

  • Profile Image
    Zbulo
    Answered on January 07, 2022 at 05:56 AM

    Thanks Richie.

    There are two Spreadsheet to Form-widgets, I named them "Loading" and "Load" as this is least confusing for the user when it's displayed upon form load. Both use an identical dataset but different identifier columns to look up and fill the same fields on the first page: Tour, Start, End

    1. Widget shown: I couldn't identify a condition's conflict but maybe missed something.
    2. Widget not working: Once I moved it to another page, so the widget is not showing upon form load, they stop populating the respective fields.

    I hope this makes sense,
    Ricardo

  • Profile Image
    Michal_S
    Answered on January 07, 2022 at 06:48 AM

    Hello!

    I've reproduced the issue with the widget showing for a split second after load - this has actually always been the case - the widget does take some time to hide.

    This is due to the fact the widget is inside an iframe - it first loads, and then applies the styles that cause it to be hidden - there's a split-second discrepancy in the timing of those actions.

    From what I'm seeing, the user does not have to interact with the widget at all - if I'm correct in my assumption, please add the following code to your form's Custom CSS - as the form's CSS gets applied before the widget's CSS, this will successfully make the widget hidden from the start:

    #id_142, #id_167{
     display:none!important;
    }


    How to Inject Custom CSS Codes

    As for the fact that the widget is not working when placed on another page, I've managed to reproduce that too - I will be splitting it off into a separate thread and will address it there:

    https://www.jotform.com/answers/3647748

    Thank you!

  • Profile Image
    Zbulo
    Answered on January 07, 2022 at 07:33 AM

    Thanks for looking into this and explaining the background too Michal.

    You're assumption is right, I inserted the code and this hides the widget - great! :)

  • Profile Image
    Jovanne_A
    Answered on January 07, 2022 at 07:40 AM

    Hi, thank you for getting back to us.

    We're glad that you were able to fix the issue.

    Let us know if you need further assistance. We are always happy to help!