Swap data source for a form?

[p.behr]

The data source current used by the form is fairly complicated, and it's used in several other widgets (so I can't just change the existing data source).
The form is also a bit complicated (several field groups, custom columns and sizes, etc) and the form is referenced all over the place (scripts, filters, back-end programs, etc.).
What I want to do is replace the existing data source with a simplified version, without having to recreate the form, the app, the scripts, etc.
I understand that the results returned by the new data source must be the same as the old one.
Is there any way to change the data source for the form?

[sean.lanktree]

There is no built in functionality to do this.
I would suggest trying the following:

• Create your new data source and take note of the id
• Save off your form via Export > Savefile
• Take note of the id number of the form
• Update table VVWDG100
  • Find the record where VVID = the form id
  • Update field VVDSID to your new data source id
• Update table VVWDG200
  • Find the record where VVID = the form id AND VVPROP = 'dataSourceId'
  • Update field VVVALUE to the new data source id
• Open (for edit) your form widget and verify that it works...save it.
• Open (for edit) one of the applications that uses this form widget and save it.
• Run application and verify it works.

[p.behr]

Thanks! I will give that a shot and let you know :D

[p.behr]

Initial tests look good.
In VVWDG100 there's also VVSRC, which I changed as well.
At first both widgets were still showing in NAB, but that was resolved after a fresh log in to the portal.
Thanks!!