Re: Submit calculated field to database

Clay Fox — Sun, 02 Dec 2007 06:35:10 GMT

If you have a database type form you can submt what you query back to the database. You may want to check out the Database Accelerator and web services if you want more flexbility with how you query and submit.

Qdabra Database Accelerator Suite Version 2.1 - Developer

Submit calculated field to database

barmatt80 — Fri, 30 Nov 2007 20:36:23 GMT

I have been searching around the forum here and alot of useful and great information!

I have created a form that is based off a data source(sql server) with some managed code(VB.net). I am creating the form within Infopath 2007, however it has to be backwards compatible with InfoPath 2003, and eventually will publish form on MOSS.

The form is a request for time off. User will query information from the database to fill the form. There are 3 fields: AnnualForward, RequestedHours, and NewBalance. AnnualForward is pulled from the database, user then enters the amount of hours requested off in the RequestedHours field. The remaining amount of leave is calculated and result is put in the NewBalance field.

What I am needing to do is when the user submits the form, the NewBalance field is submitted back to the database in the AnnualForward Field. That way next time the new available balance is pulled when queried.

I hope I have explained this well enough.

Thanks.

General

Re: Submit calculated field to database

Submit calculated field to database