Spreadsheet Widget: Error at A11: Unexpected token '&: Hebrew characters

Hi

Starting this morning the "spreadsheet" widget is not working in my forms.

"Error at A11: Unexpected token '&'"

please help...

thank you!

Hi Hemdat,

Thanks for reaching out to Jotform Support. I cloned your form to test it, and I easily replicated the issue. The spreadsheet widget can't read some of the column labels written in Hebrew alphabet. Also, short lines included in your multiple cells (b11, c11, d11, e11, e11, f11, g11) shown as an error in the widget. What you can do is, to create Spreadsheet using different language, or, creating it once again. Check out the screencast below to see my result after removing the fields that cause an error:

When I created a new Spreadsheet, I've copied the column labels written in Hebrew into default values and there were no issues. Let me show you how to do that:

1. In Form Builder, select your Spreadsheet and then click on the Wand icon.
2. Remove every default value that includes short line or Hebrew letters.
3. Copy column label and paste it to default value field
4. Lastly, click on Update Widget.

We also have a guide on How to Set Up the Spreadsheet Widget that you can check out.

Give it a try and let us know if you need any more help.

Hi,

I have been using this specific form, with the widget, for two years without any issues. I cannot change my workflows or tables right now. I urgently request that you fix the problem and restore the form to its previous working state (I haven't made any changes to the form). This is a form where lecturers report their hours and wages, and because it's not working, people are not getting paid!

Your prompt attention to this matter is appreciated.

Hi Hemdat_nehoray,

Thanks for reaching out to Jotform Support. We’re sorry you're having difficulties with this. ​​I checked your form and had the same issue, so I created a ticket and escalated this to our Developer team.

Although we don't know exactly when the issue will be fixed, we’ll circle back to this thread when we have an update.

Thanks for your patience and understanding, we appreciate it.

Hi,

This issue is critically affecting my ability to pay salaries. It needs to be resolved immediately. Please expedite.

Thank you.

Hi Hemdat,

Thanks for reaching us back. We're sorry to hear that the issue persists and understand the negative impact it does on your workflow. Rest assured, this issue is being investigated right now by the relevant team. I'll send a follow-up message, so please continue to monitor this support ticket for updates.

We appreciate your patience.

Hi!

please try to fix it by tomorrow, so i could pay this month salaries.

Hi Hemdat,

Thanks for getting back to us. I am sorry this is happening. I checked the form, and it shows that my colleague already escalated this to our Developer team. As soon as we hear back from them, we’ll update you here on this thread.

Thanks for your patience and understanding, we appreciate it.

Hi Hemdat,

Formulas cannot take quotation marks or two equal signs:

a11 = " =שעות ושכר"

Formulars are operands and require a valid syntax to work properly.

Do tell us what you want cell A11 to do, and we can advise on the correct formula for that cell.