I have a very simple Dynamic Form that utilizes two drop down fields, the first of which selects a particular event date.

What I would like to do is create a custom view, whereby the user can select a date from the drop down list and display only the fields for that particular date?

If that makes any sense.  It's basically a volunteer roster so people can see who is assigned to what and which positions are not yet filled, selectable by the date.

Any guidance would be appreciated

Hi Wendy,
I share a long explanation here on what looks like you are doing. Please read as there may be a problem based on what I see what looks like you are trying to do with two drop downs. The answer is that a Dynamic Views with the Dynamic Forms will make things a lot easier. Read below:

Sounds like you will have a dynamic form (1st instance) that allows admins to fill a flat table ( i.e. DynamicForms_Events) with all the data which would be something like this: DynamicForm_ID, Event Date,Event Name, Address, .... ( and what ever else you need to capture with the events).

Then create a stored procedure to drop and then create a view off of the table above. Syntax like this:

CREATE OR REPLACE VIEW [Event Date List]
AS
SELECT DISTINCT DynamicForm_ID, EventDate
FROM DynamicForms_Events

Above can be done in a stored procedure in the database like Sp_CreateEventDates which runs above SQL.

Then have a second instance of Dynamic Forms where use SQL binding to call stored procedure that makes view of dates. This will populate your 1st drop down list. Lets call 1st drop down list: Event Dates List so short name would be: $(EventsDatesList). The second drop down would be populated by SQL that uses the date value chosen from the 1st drop down as part of where clause on another query like this that might be in a sql completion event as follows:

Select field1,field2,... from dynamicforms_events where EventDate = '$(EventsDatesList)'

Result is that you want the 2nd drop down list to be only info from date selected. Now for your 2nd drop down what is it going to display? You will have to follow the following convention for working with dynamic forms. You will see this suggestion in the Dynamic Forms module as follows:

QuestionOption and QuestionOptionValue. (I.E. select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'EventName'') <-- Note 'Region' probably = "EventName" field in your DynamicForms_Events table.

********************NOW FOR A BIG QUESTION*********************

I don't know about having 2 drop down lists as the right way to go.

The 1st drop down will be distinct list of all dates in the DynamicForms_Events table. Then the 2nd drop down will be a limited list will be constrained by the QuestionOption, QuestionOptionValue scenario so only a single value will populate that drop down-- like all the Event Names for the date chosen in the 1st drop down list. --- Do you see a problem here?

[U] POINT IS Dynamic Forms is made for capturing data and does a good job of that but to display data that is where the Dynamic Views module comes in.

Hi Wendy,
My additional comment to the above is that maybe I don't know quite what you are trying to do. If I am off base to what you are doing let me know and I can try and help you again.
Thanks

Thanks Don!

I think I am making this more complicated than it needs to be (but that's nothing new for me)

Anyways, the only drop down I want to select is the event date, then display all the fields from the second drop down list with the person assigned to that task, for that date.

Does that make sense?

So if I have a date of September 1, 2011, all the volunteer positions, regardless of the date, remain the same the only differences are the people assigned to those positions. I just use the volunteer position drop down to assist in not having to manually enter the same position title multiple times.

Maybe I need a different approach?

Hi Wendy,
Ok, looks like your problem falls into the category of what is seen on DataSprings with the Dynamic Forms demo 11 as seen at this link: http://www.datasprings.com/products...tration-11

If this demo looks like it is doing what you are trying to do then I have to ask if your data is already set up in a relational database.

Demo 11 uses the AdventureWorks database with three tables: ProductsSubcategory, ProductCategory, and the Products table. Looks like your situation's data may also involve at least three tables to be set up correctly like: Events, Volunteers, and Volunteer Positions. A fourth table would be needed for a many to many relationship that might exist between volunteers and volunteer positions. Does you data look something like that in your database design?

At any rate let me stop here and ask that you get back with me some answers so I can see better how to advise you.

Thanks