Forums

I have a table of data using CC6 that shows data for a given year. I would like to have a drop down at the top of the page that allows me to show the data for the selected year. I have done multiple dynamic Dropdowns in CF6 successfully and see where multiple drop downs seems possible in CC6 but I but can't seem to figure out if it is possible to update a table in CC6. I have the drop down created and loading the "years" and I have the Events for the Dropdown set to On:Change, Actions:Reload, Element ID:SeasonSchedule (Table name). I dont see how to setup the "dynamic reload event" as I would in CF6.
​
Is this even possible?
​
If so how?
​
thx,

Instead of an onchange action, have a "filter" button, pointing at your index event (or whichever event you're displaying your table in). In the where condition of your read data action you should have something along the lines of
​

YEAR(model.date):{date:Y$(data:date_filter_field)}/-

OK so I am not a programmer by trade and I have spent the better part of 2 years muddling my way through these 2 products (mostly chronoforms) to meet some really basic data gathering needs but in the last 6 months have tried to expand what I am doing and figure it out as I go but dont completely know all the different parts a pieces of the products.
​
When you reference my read action are your referring to my "read_season" function which calls the years I want the end user to chose from or the "read_schedule" function that pulls up the data for the "selected" year?
​
I am only familiar with buttons to submit data on forms. Are you talking about a field:button or a Elements:Task or Toolbar Button? Do you happen to have a sample of how this might be setup?

Pretty sure it's a toolbar button but I have to check, doing some yard work at the moment.
​
And I'm referencing the read schedule function.

and you have completely lost me. This is what I understand (which isnt much)
​
Create a Form:Form. Name:FilterSeason Event:FilterSeason
​
I have never used a Form:Form. how do I put my dropdown in this form (and the submit button)?

I think i have figured it out...

OK so I have figured out the "hard part". I have it selecting the season and populating the table correctly when I hit select. now for the formatting part. Can I put the "SELECT" button next to the drop down (instead of below it)?
​
my form contains:
​
<b>SELECT SEASON</b>
{view:SelectSeason} {view:FilterSubmit}
​
but the button appears below the dropdown.

If you want the inputs (dropdown, button, text, textarea, etc) to be in a row:

1. Under Views, create a Form. (Forms > Form)
2. Add a "Multiple" input.
3. Click on the small green tick at the bottom left of the new box that just appears. This selects the box as the target to add new inputs.
4. Add a "Dropdown" input.
5. Add a "Button" input.
6. You'll notice the Dropdown and Buttons inputs are now next to each other.