CC6 Dropdown to Reload(Update/Refresh) a Table

Update a CC6 table based on a dropdown selection.

Overview

The issue occurs when trying to refresh a table dynamically after a dropdown change, as the onchange reload action does not work as expected in CC6.
Use a form with a dropdown and a submit button instead. Set the form's submit event to reload the table, and apply a filter condition in the table's read data action to display only the selected year's data.

Answered
Connectivity v6
vi vividal 18 Nov, 2018
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,
he healyhatman 18 Nov, 2018
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)}/-
vi vividal 18 Nov, 2018
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?
he healyhatman 18 Nov, 2018
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.
he healyhatman 19 Nov, 2018
Answer
1 Likes
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
vi vividal 19 Nov, 2018
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)?
vi vividal 19 Nov, 2018
I think i have figured it out...
vi vividal 19 Nov, 2018
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.
we webbusteruk 07 Dec, 2018
1 Likes
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.
This topic is locked and no more replies can be posted.