Jump to content

PacWebDev

Members
  • Content Count

    4
  • Joined

  • Last visited

  1. We have separate fields in our profile table for first name and last name. Currently have a "one ring to rule them all" search bar that is supposed to search all given fields in that table for any keyword entered. The fields we are using are firstname, lastname, FULLname (a concatenated entry derived from first, middle and last), category and keywords. So a person can enter "John" for example and get all profiles with the name John in them -- including e.g. last name Johnson. Problem is, if they enter a full name, such as John Smith, it returns NO results -- even if there are four people surnamed Smith, or three people named John. http://go.pacific.edu/findanexpert -- that's the live; if someone could assist with this it would be most appreciated. I did search for this question but the closest I could find was this thread -- and it wasn't exactly what I needed, sorry. I have tried configuring this with specific logic "rules" on the fullname but it wants to "reset" these every time I try, so no go.
  2. Pardon the thread necromancy but my Q is similar to this one so I thought I would share it here. We have separate fields in our profile table for first name and last name. Currently have a "one ring to rule them all" search bar that is supposed to search all given fields in that table for any keyword entered. The fields we are using are firstname, lastname, FULLname (a concatenated entry derived from first, middle and last), category and keywords. So a person can enter "John" for example and get all profiles with the name John in them -- including e.g. last name Johnson. Problem is, if they enter a full name, such as John Smith, it returns NO results -- even if there are four people surnamed Smith, or three people named John. http://go.pacific.edu/findanexpert -- that's the live; if someone could assist with this it would be most appreciated.
  3. Between the time I posted this and the time it got approved for display, I figured out a few things that might be worth sharing here. When I have more time I will post some of my lessons learned; for now, the solution I was seeking above is available on this page: http://forums.caspio.com/index.php/topic/4315-js-multiselect-listbox-in-update-datapage/
  4. This is a fabulous solution for the search ... but how would we go about implementing multiple selection for entry into the actual table itself? For example, I have a table with a list of various "categories" and each has a unique ID. I also have a "profiles" table and any given entry in that table might have one or more appropriate categories -- e.g. "history" and "political action". I want to read from that categories table to populate the listbox and, in the entry form (to add new people to the "profiles" table) I want to have the selections of the listbox saved as an array of the category ID numbers. This array, in turn, should then be stored in the appropriate field of the "profiles" table so that entries in that table can be searched or looked up by category, with the two tables associating with one another. I'm currently working on a variety of modification ideas to Emma's script to try to get something that will do this, but I think the Caspio interface is getting in the way or else my javascript-fu isn't what it should be for this task. If someone could offer assistance it would be very much appreciated. Thank you!
×
×
  • Create New...