I've created a couple of contour forms that store data in a sql table (we'll need them avaialble to create reports on). However, I'm not able to export the files and move between our different environments as they fail to save to the database. The data sources have the same names but I'm guessing the different environments will have different Id's (Guids?).
Is there a way around this as it is going to be a pain to have to recreate the forms on each environment.
Also forms that use a database as a source seem overly restricted, you can't change the types after the first design. So when I needed to make a string field a hidden field I had to delete the form and start again. Led to a frustrating day while I got my head around the qwirks and had to keep recreating forms. I'm dreading anyone asking me for changes.... :/
Issues with SQL datasource and dev/test/live
Hi All,
I've created a couple of contour forms that store data in a sql table (we'll need them avaialble to create reports on). However, I'm not able to export the files and move between our different environments as they fail to save to the database. The data sources have the same names but I'm guessing the different environments will have different Id's (Guids?).
Is there a way around this as it is going to be a pain to have to recreate the forms on each environment.
Also forms that use a database as a source seem overly restricted, you can't change the types after the first design. So when I needed to make a string field a hidden field I had to delete the form and start again. Led to a frustrating day while I got my head around the qwirks and had to keep recreating forms. I'm dreading anyone asking me for changes.... :/
Any suggestions?
Thanks,
John
Comment author was deleted
Doesn't updating the con string on the different environments do the trick don't think you need to recreate the form
is working on a reply...