Buy Now
Sign in

Adding a filtering function to my table generated by CC6

MTUG , March 30 2020, 09:49
M
MTUG 16
March 30 2020, 09:49 #391828
Hey,
Im working with building a website that contains information about different medica projects. The medical projects are added to a database using a form created by chronforms. Thereafter all projects are displayed in the website by a table created by chronoconnectivity. see the pictures below:
Screenshot_1.png
Screenshot_2.png
I want to create a filter function to all the headers. So i want to make it possible to view for example only CT projects or only Paused projects.
I should also mention that i have only been working with joomla, CF6 and CC6 for approximately one week. So a detailed explanation is appreciated.
healyhatman 9
March 30 2020, 10:34 #391830
 Answer
In your read data action, add some conditions, e.g. columnname = {data:fieldname}, and set the dropdown to "continue" as in "if it's not entered in, ignore it"
Create a Form Area, put the fields you want in there, have it submit to the index event.
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
M
MTUG 16
March 30 2020, 11:21 #391831
Thanks for your answer.
I've added a 'conditionä in my read data action. looks like this:
Screenshot_3.png
I've also created a form area. but i dont understand how i should fill the fields.

Screenshot_4.png
Attachments
Screenshot_3.png
Screenshot_3.png
(30 KiB)
165 Downloads/Views
Screenshot_4.png
Screenshot_4.png
(27.71 KiB)
165 Downloads/Views
healyhatman 9
March 30 2020, 11:24 #391832
Now create a text field and put it inside the Form Area's "content" section using {view:name_of_your_text_field}
And don't literally write "columnname" in the read data where condition, write the name of the column you're going to use that text field to filter on
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
M
MTUG 16
March 30 2020, 11:45 #391833
I did create the text field and put it in the Form Area's content. The result is i did get a field on the webpage ( see image below) but when i type CT for example to filter only CT projects i didn't get any response.
result.png
more screenshots on attachment
Attachments
result.png
result.png
(11.29 KiB)
153 Downloads/Views
events.png
events.png
(14.73 KiB)
109 Downloads/Views
functions.png
functions.png
(41.48 KiB)
117 Downloads/Views
views_form3.png
views_form3.png
(38.94 KiB)
112 Downloads/Views
views_modalitet.png
views_modalitet.png
(18.48 KiB)
114 Downloads/Views
views_form3.png
views_form3.png
(38.94 KiB)
113 Downloads/Views
views_table1.png
views_table1.png
(39.13 KiB)
105 Downloads/Views
healyhatman 9
March 30 2020, 11:48 #391834
Did you submit the form, or just type in it?
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
M
MTUG 16
March 30 2020, 11:49 #391835
I typed and pressed Enter
healyhatman 9
March 30 2020, 11:53 #391836
And it's submitting? What does your debug say?
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
M
MTUG 16
March 30 2020, 11:57 #391837
I would say it is submitting cause i get a loading logo after i press enter. but the tabell won't update.
I don't really know about debug. Sorry i'm very new to this.
In 'Functions' 'Condition' the value should it be data.modalitet ? or should data be replaced by my database name?
M
MTUG 16
March 30 2020, 12:21 #391838
I did write:
{function:read_projects}
{view:form3}{debug:}
{view:table1}
In the events and i got:
debugg.png
Does it tell you anything?
Attachments
debugg.png
debugg.png
(27.91 KiB)
144 Downloads/Views
M
MTUG 16
March 31 2020, 08:06 #391848
I figured it out. i should have data.modalitet to data.text4
because the textfield i've created called text4
Thanks for help!:)
M
MTUG 16
April 01 2020, 09:18 #391866
My next challenge would be to add an edit button to my project list(see picture below):
search.png
so the idea is: The user should be able to search for a project (or projects) and can simply edit the project (for example change the status) by clicking on the edit button.
can you help me with that:)
Attachments
search.png
search.png
(25.24 KiB)
97 Downloads/Views
search.png
search.png
(25.24 KiB)
126 Downloads/Views
healyhatman 9
April 01 2020, 09:22 #391867
There are demo connections that can help you with that.
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
M
MTUG 16
April 02 2020, 12:47 #391882
Hi again,
Thanks for your answer. I've been looking at the demo connections. There is something i dont understand.

In the demo connection there is an edit button, when i press edit. The title of the article that i have chose to edit is already written in the text field. what is the function that does that? i have tried to build my connection in the same way but the when i press edit i get en empty form ( see pictures below).
Screenshot_1.png
This is build with with demos 'basic articles list'. When i click on edit i get the following widnow where article title is automaticly filled.
Screenshot_2.png
Also, can i make so when i click edit i get my already designed chronoform with the informations of the specifik project so i can edit multiple lines?
Attachments
Screenshot_1.png
Screenshot_1.png
(5.24 KiB)
118 Downloads/Views
Screenshot_2.png
Screenshot_2.png
(7.38 KiB)
116 Downloads/Views
admin 28
May 24 2020, 10:30 #392722
do you still need help with this ?
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
M
MTUG 16
May 25 2020, 06:38 #392745
No I've figured it out.
Thank you!
admin 28
May 25 2020, 06:50 #392746
Great, we are making ready the new ChronoForms v7 which has an easier to use data listing features, so in the future you better use it instead of CC6
Best regards
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
M
MTUG 16
May 25 2020, 06:58 #392747
 1
Nice:)