-
That is kind of a pain, isn't it.... Well, you could copy your original people picker, and paste it on your form a second time. Have one with the yellow fill, one without. Use conditional formatting to hide the non-yellow one if the field is blank, and hide the yellow one if it isn't blank (since you can have conditional formatting to hide ...
-
Is your form template set to be a browser form (either using "save as" to save as a browser form, or you can set it under the Advanced Options / Compatibility)? Does it have any custom code in it? Anything in the design checker?
-
You'll need to create a secondary data connection to your SQL table (you have DBXL, so you can use QueryDB for that). Then, the tricky bit is going to be copying your secondary data into your main data source --
Basically, you'll need to insert how ever many number of rows returned by your SQL query to your main data source. Then populate ...
-
Since you are submitting your data to the "CYLINDER_MEASUREMENTS" table, you need to have that be the table you use for your data connection.
"CYLINDER_DATA" would be a secondary data connection in your form. Your drop down where the user selects the Cylinder Id would use the Cylinder Data data source to provide it's ...
-
I think you are saying that when you view the form in the browser, one control doesn't display the default value? Is this a default value? Does it depend on a secondary data source? Are the post back settings the same on all the controls?
For IP 2003, the order of processing on startup is user roles, open rules, OnLoad ...
-
So, I think what you are saying is that when the form is opened, you want to have a table with all the traits and the user can select a rating for each trait? Then the user submits, and the data goes into your target table?
The tricky bit then is that you'll need to insert groups into your main data source, and copy in the Traits -- because ...
-
Hey, welcome...
When you say:
[quote user="JackInBoston"]The trait field has about 20 different values that i have setup as a lookup. [/quote]
What do you mean? Do you mean that the control bound to the trait field is a drop down control? What are you using for the data source? Is it a secondary data source? Where are the ratings ...
-
Hi:
I think my first question would be why you need to do this -- sometimes there are other alternatives to code.
However, if you must write code, here is an MSDN link that may help you.
-
Walk through your submit connection again in the Data Connection Wizard. Make sure you've selected the box that allows you to overwrite existing files. Make sure you are using something unique for the file name (a date in the formula always helps with that ... now() is a good date to use).
-
FormStatus, as a variable, appears to be a field in your main data source. At least based on your form code.
In your if statement, you check if it is equal to request, and you set the field to "Approval", and you send an email and submit to your form library (which saves the XML).
In your else statement, you check if it is equal ...