What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Update All Submission Records to Add a 0 before the Phone Number

    Asked by saud100 on October 06, 2015 at 10:50 AM

    Hi, Have form has for example 1000 records i need to update all of the records for example if i have phone number like this

    500500 i want to add 0 before each record.

     

    how i can do this?

    thanks

     

    saud

    update data phone number thanks all records
  • Profile Image
    JotForm Support

    Answered by KadeJM on October 06, 2015 at 01:14 PM

    I believe I understand that you mean though I'm not entirely sure. It seems to me that you want to update all of your submissions (records as you are calling them) for a form phone number field to include a " 0 " before each of them? And you want this done all at once via a mass update to each? 

    So for example you have 3 submissions with the phone number you want to be able to update all of those to have a 0 in the begging of each submission that you've already received.

    Submission A = Phone: "0" 500500

    Submission B = Phone: "0" 500501

    Submission C = Phone: "0" 500502

    "  Etc, Etc, Etc.....       "

    Can you please confirm that's what you are talking about above or correct me in case I have misunderstood you in any way? 

  • Profile Image

    Answered by saud100 on October 06, 2015 at 03:57 PM

    Yes. exactully that what i need.

  • Profile Image
    JotForm Support

    Answered by KadeJM on October 06, 2015 at 04:10 PM

    Thank you kindly for confirming that.

    Unfortunately, to my knowledge we don't have an exact method of "mass editing" "all submissions" per say that I know of as of right now since it is only possible to edit submissions one at a time.

    However, One way you could work around the issue to make it work to your advantage would be to download your submissions as an export to Excel and Csv. You could then use your spreadsheet software to make those changes quickly. Once done you can then re-import them with our Import Data App to get them with the updated Phone Number back onto your form.