Buy Now
Sign in

CC6 Dropdown to Reload(Update/Refresh) a Table

vividal , November 18 2018, 14:02
V
vividal 117
November 18 2018, 14:02 #381568
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 7
November 18 2018, 21:39 #381575
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 DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
V
vividal 117
November 18 2018, 23:26 #381576
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 7
November 18 2018, 23:53 #381577
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 DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
healyhatman 7
November 19 2018, 00:40 #381579
 1
 Answer
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 DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
V
vividal 117
November 19 2018, 00:49 #381580
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 117
November 19 2018, 01:19 #381581
I think i have figured it out...
V
vividal 117
November 19 2018, 01:28 #381582
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 116
December 07 2018, 01:25 #382042
 1
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.