-
You should be able to add the web service data connection as a submit type.
Then just have a button which initiates the submit.
If you need help with webservices, check out the tutoials area in downloads.
-
Hey Russ.
I would check out www.formotus.com
-
You have to save the data in your form's main data. As you have found secondary data is not saved with the form.
So when they pick a secondary row, copy it to one in your main data source.
-
You should use a hyperlink control.
Use a concat function on a field to create the URL between the DL path and the filename.
-
Hey Kyle.
As you have found, the default database functionality is limited. You can only submit a database type form to one table.
With webservices and SQL express you get much greater flexibility.
You could possibly use code to do this second submit.
I would suggest you use Access.
If you have the data in tables already I would run a process ...
-
When you say populated are you referring to an existing form in a library?
Or you want some default data or something?
-
Hey Patrick.
Not that I know of.
You can list views in the toolbar but I do not believe there is a way to access them there with keystrokes.
You could have buttons in each view and with tabs switch to the button and then select it without leaving the keyboard.
If their were set places where the switch would occur that might work.
-
Best Practice is to get webservices, like the tools from www.qdabra.com, and then you can take your existing form and have it submitting to your DB in under an hour.
As far as Table setup. You typically want to look at your main schema and any repeatin nodes in your schema would be relational child tables in the DB. Each form would be ...
-
Create a field in your main datasource called filename
Add a open rule (Tools, form options, Open, rules)
Add a condition if filename is blank.
Set filename to now()
Then in your submit for the filename just reference the field.
-
Yes the publishing is the key.
That is how the location of the template is set in the resulting forms.