My form is seriously error

  • Hangchanleakna
    Asked on January 17, 2019 at 9:59 PM

    my Survey form , Survey for Non sales team , 

    i use the drop down box with 20K outlets with the calculation to be detect to other Widget , it turns out wrong data . 

    means , if i click on Outlets name , it should show the result of this outlet whether it's in Gold , Silver or Bronze , I set the condition alr . but look like it turns all error , 

    the result only seen Gold. , even the outlet name is in Silver or Bronze. 

    please urgently fix on this  , the form is on LIve :( 

    not happy with the result 

  • Victoria_K
    Replied on January 18, 2019 at 3:53 AM

    Hello Hangchanleakna, We will gladly help to set up your form. I have checked the form Survey for Non-Sale Team ( Supporter )  form and can not locate drop down field you have mentioned. Also, it seems that one or several fields were deleted as I see some conditional statements that are broken at the moment. Could you please fix statements or remove them? 

    If you will need help on this, please let us know.

  • Hangchanleakna
    Replied on January 18, 2019 at 4:01 AM

    hi , 

    i have removed auto complete form and other form calculation widgets , as mentioned the outlets i input in Auto Complete form are around 25K rows which means more than 64000 characters, it lost some data on the form calculation when i set the condition. 

    My question , whether we can only use Spreadsheet form for this such rows ? 
    Actually i prefer the widgets i am using previously , but it turns distracted and error to the other information i detected to. 



  • Richie JotForm Support
    Replied on January 18, 2019 at 8:52 AM

    I'm not sure I understood your question clearly. May we know the flow of your form? How do you want to use the auto complete widget fields?

    We will wait for your response.

  • Hangchanleakna
    Replied on January 18, 2019 at 10:16 AM

    I used auto complete widget with 25k rows of the data more than 64000 characters that it can handle.

    and I use 3 drop down box with 25K rows which open the calculation too . 

    The reslt are like populated fields.and it lost more than half of the rows data. 

  • Victoria_K
    Replied on January 18, 2019 at 11:22 AM

    As far as I understand, you have inserted more characters into the widget and exceeded the limit. In case of Auto Complete widget, the field is limited to 50K characters. If you manage to insert more characters, the data will be cut off upon reloading the form builder page. We can suggest to please split the data and add it in multiple widgets.