Hello All-
I am hoping someone can help me... I have a customer information form that collects a large amount of data, it is working fine and I know how to pull the data into connectivity. What I am wondering is if it is possible to create a connection that only grabs the customer names and puts them into a drop down list that you can choose from and when you choose a customer to have it then go to all of that customer's info.
If I were to list all of customers and their info on one page it would be a mile long. I know that I can set it to only list 1 on each page but then there is no way to get to a specific customer without paging through all of them. I am sure that this is possible but I am not a php or javascript expert so I am not sure where to begin.
Thanks in advance to anyone that can shed some light on the situation!
I am hoping someone can help me... I have a customer information form that collects a large amount of data, it is working fine and I know how to pull the data into connectivity. What I am wondering is if it is possible to create a connection that only grabs the customer names and puts them into a drop down list that you can choose from and when you choose a customer to have it then go to all of that customer's info.
If I were to list all of customers and their info on one page it would be a mile long. I know that I can set it to only list 1 on each page but then there is no way to get to a specific customer without paging through all of them. I am sure that this is possible but I am not a php or javascript expert so I am not sure where to begin.
Thanks in advance to anyone that can shed some light on the situation!
Hi arkmedia,
You can do this by adding a drop-down box in the Header of the Chronoconnectivity page and using the form result in a WHERE clause for the list. This is a bit fiddly but not too difficult.
However the drop-down is likely to be very long too . . . a better answer here would be an AJAX linked search box so that once you typed a few characters it would check the database table and show you a drop-down list of the matching results.
Bob
You can do this by adding a drop-down box in the Header of the Chronoconnectivity page and using the form result in a WHERE clause for the list. This is a bit fiddly but not too difficult.
However the drop-down is likely to be very long too . . . a better answer here would be an AJAX linked search box so that once you typed a few characters it would check the database table and show you a drop-down list of the matching results.
Bob
This topic is locked and no more replies can be posted.
