Joomla 3.9.10
Not sure if this is a Form or Connectivity project, or combination.
Want a textbox, or two, that searches 2 related tables. If the searchbox has no value then no records are returned, ie the page shows only the search textbox.
The searchbox will search all records but only in 2 fields. If it finds a match, then those 2 field values plus other fields will be returned.
EG, search the name and company fields and if a match is found then return a table list with names, company, title, phone , ext.
This what I currently have and want the listing to be invisible until the search term calls the record or records
https://snag.gy/r9awBJ.jpg
Thanks
Not sure if this is a Form or Connectivity project, or combination.
Want a textbox, or two, that searches 2 related tables. If the searchbox has no value then no records are returned, ie the page shows only the search textbox.
The searchbox will search all records but only in 2 fields. If it finds a match, then those 2 field values plus other fields will be returned.
EG, search the name and company fields and if a match is found then return a table list with names, company, title, phone , ext.
This what I currently have and want the listing to be invisible until the search term calls the record or records
https://snag.gy/r9awBJ.jpg
Thanks
In the read data action there's a dropdown on the right of each where condition, you can set it to "stop" if the condition isn't found.
Then you can check if read data is empty, and if it's not display the table.
Couple of other ways you could do it but I'm super busy right now and that's the fastest.
Then you can check if read data is empty, and if it's not display the table.
Couple of other ways you could do it but I'm super busy right now and that's the fastest.
Thanks Healyhatman
So I think I should write the visibility rule in the rules list in read data.
But don't know the syntax.
Something like
if notisnull{var:member_data} then {var:member_list.visibility = true}
"member_list" is the view that gets data from the read data action "member_data"
Where can I get rules syntax? Is it php?
Thanks
So I think I should write the visibility rule in the rules list in read data.
But don't know the syntax.
Something like
if notisnull{var:member_data} then {var:member_list.visibility = true}
"member_list" is the view that gets data from the read data action "member_data"
Where can I get rules syntax? Is it php?
Thanks
None of what you said sounds right sorry you might need to have a look at some of the demo connections
This topic is locked and no more replies can be posted.
