Method Community

Hello Method,

I am getting an error when I try to save changes to a profile screen. "Invalid column name 'BillAddressAddr2'. Please verify this field is in the table you are trying to update.

This happens on the ContactsPortal_EditProfile Screen when I change the billing address field and click the Save Changes button it returns the error. I have gone through the whole screen looking for action errors, and checked that the field is in the table, but can't seem to find the problem.

Are you able to look at my exact account and see the problem?

Best Regards,

Matt Low

Matt,

Have you tried regenerating the table (opening the table and clicking "Finished Editing Fields")?  Have you tried republishing the screen?

- Adam

Adam,

Yes I have regenerated the table multiple times, tried pulling the filed from another table and refreshed the screens. Can I delete the field from the contacts table and then readd the field?

Matt,

You won't be able to delete the field since it is used in other screens.  Can you exit out and make sure all screens are closed properly, and try regenerating both the contacts table and the entity table?  Then sign out and sign back in again.  

- Adam

Hi Matt,

I had the same message appear when I was referencing a linked field in an Insert Record into Table action and also the Update Field in Table action.  I was able to fix it by identifying the field on the table by Record ID # instead of Text.

Your situation may not be the same as mine, but I hope this helps.

April Hooper

April,

Thanks for the suggestion! 

- Adam

I deleted the screen and started over. That fixed the problem. thanks.