Spreadsheet to Form widget issues

Hello Jotform team,

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.

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

• Loading: Takes it value from the user selecting Group departure / Select a tour
• Load: Is supplied by a payload / link prefill, for example https://form.jotform.com/Zbulo/book?code=SHPOB224

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

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!

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! :)

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!