(May 24th, 2010, 9:21 AM)iroast Wrote: Why not keep it simple? 2 forms / 2 dbs. Link Banks to Form 1 and Buildings to Form 2? You wouldn't need that drop-down menu if you do it this way.
Thanks for the input, but generally the user filling out the form will not know which dropdown option to select untill they fill the previous fields as the coding that is scripted for the html form itself only presents the drop down options based on the users selections and input in the previous fields.
So having the html form point to just 1 database and filtering the submissions is the easiest way as I've already done but was just curious as to any possibility to have the array which determines which database form it sends the submission too based on the drop down selection.
Also. To ask if I may @ Ben
When creating a specific view with filters, I have a view that I want to display total submissions made "Today".
I created the filter with the field option as 'Date' , selected Today's date in the After / Before. Which works fine.
Trouble is I have alot of views with other various filters that include Today's Date, that I have to manually go into and change the date range to Today's date.
Is there a way that I've overlooked or can incorporate the portal to automatically update the view / filter to today's date or do I need continuously change each view's date range manually ?