Buy Now
Sign in

CC6 Dropdown to Reload(Update/Refresh) a Table

vividal , November 18 2018
Answered
V
vividal
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,
healyhatman
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)}/-
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman

DON'T COPY+PASTE FROM THE FORUMS! It adds hidden code-breaking format characters!
V
vividal
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?
healyhatman
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.
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman

DON'T COPY+PASTE FROM THE FORUMS! It adds hidden code-breaking format characters!
healyhatman
OK so you need:
A Form element with the submit event being the event you're already in. So either index or {data:event}
-> Containing a Fields element
-> With your dropdown inside and
-> A submit button
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman

DON'T COPY+PASTE FROM THE FORUMS! It adds hidden code-breaking format characters!
V
vividal
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)?
V
vividal
I think i have figured it out...
V
vividal
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.
W
webbusteruk
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.