Columns changed in Excel Spreadsheet

  • Profile Image
    DanBlum
    Asked on March 23, 2013 at 12:32 PM

    For the form listed below, the Excel columns assigned to each of the form's fields changed from earlier (at least 3/12/2013) to today (3/23/2013).  It appears that in creating the workbook, a field has been duplicated into three columns, sliding the remaining columns out to the right.   I have VBA programs that read your Excel workbook and process each row (form).  Although the VBA programs are table driven, I need to be able to rely on the columns not being adjusted unbeknownst to me.  Is it possible you have made an "upgrade" that has a bug in it?  In the workbook created 3/12/2013 , column AF (what I call "Waiver Accepted")  moved to AH on 3/23/2013.  Additionally column AC (what I call "CC number")  moved to AE.  I have not made ANY changes to the form definition.

    The emails that I have sent associated with the form appear NOT to be affected.

    I have a second form that is in structure much like this one  that is experiencing the same phenomenon in the same spot.  Is there something a user could be doing to cause this change?   I have been using this Form for at least 2 years and have not experienced  this.  The total application I have, that JotForm is a part of,  depends on the columns being predictable.

     

    I can be reached at d-nblum@nc.rr.com

     

  • Profile Image
    Welvin
    Answered on March 24, 2013 at 12:10 AM

    Hi Dan,

    Yes, I guess the update we have about the Payment Tools causing this to happen, although I am not sure about this. No, there's no bug on the update. You can check the changes on this Thread. The Payment Field is now divided into three columns.

    What I can suggest you to fix that is also update your VBA Program to match with the current Spreadsheet output.

    Let us know if you have any further concerns.

    Thanks

  • Profile Image
    DanBlum
    Answered on March 24, 2013 at 12:36 PM

    OK.  I will change my VBA macros.  Thanks for the quick response.

    My only comment is that Jotform updates should be upwards compatible.   Perhaps when you extended the functionality of the Payment Tool, you guys should have instead created an alternative  Payment Tool (with a different name) in order for the existing tool and applications that use it to remain compatible.  Or, you should have sent "alert emails" to all those form owners who use the affected payment Tool.

    Jotform is very successful and is vital to many of its customers operations.  Additing functionality is great, but it must be done in a non-disruptive manner.

    I remain impressed with the responsiveness of your support team.  Thank you.

  • Profile Image
    Welvin
    Answered on March 24, 2013 at 02:46 PM

    Hi Dan,

    You are always welcome. Your comments are noted as well and thank you for the feedback. Should you have any further questions, issues and concerns, please don't hesitate to contact us.

    Thanks and have a great day!