I have an excel spreadsheet with codes and descriptions of those codes. I am planning to put it on our intranet so our staff can use it. However, to make it more user friendly I wanted to create a form with a search box. Users should be able to enter either a code or a description keyword and it will bring up the relevant records.
Would this be difficult to do with ChronoForms?
Can someone please tell me or give me hints on how to do it? Do I need to put the spreadsheet in some type of database first?
Many thanks!
Would this be difficult to do with ChronoForms?
Can someone please tell me or give me hints on how to do it? Do I need to put the spreadsheet in some type of database first?
Many thanks!
Hi amagab,
You will need to migrate your codes into a MySQL table. If there are only a few you could do this with cut and paste or use a csv export - if it's a big table then Googling will find you many tools. I used a trial version of NaviCat to do a similar task a while back.
A form with a search box is simple enough. You'll need to join this with some sql to do the actual search on the data.
Bob
You will need to migrate your codes into a MySQL table. If there are only a few you could do this with cut and paste or use a csv export - if it's a big table then Googling will find you many tools. I used a trial version of NaviCat to do a similar task a while back.
A form with a search box is simple enough. You'll need to join this with some sql to do the actual search on the data.
Bob
This topic is locked and no more replies can be posted.
