Need help with autocomplete script!

Hi nmsinc,

It looks like this is using the jQuery UI autocomplete function. If that's the case, you should be able to do something like the following to differentiate the value saved from the label displayed:

   $( "#debtor" ).autocomplete({  source: [
   <?php foreach (mysql_select("debtor", "agency ORDER BY debtor_name") as $Groups): ?>
   <?php if ($CURRENT_USER['agency'] == $Groups['agency']): ?>
   {
   value: "<?php echo $Groups['num']; ?>",
   label: "<?php echo $Groups['debtor_name'];?> - <?php echo $Groups['debtor_address_1'];?>  <?php echo $Groups['debtor_city'];?> <?php echo $Groups['debtor_state'];?>"
   },
   <?php endif; ?>
   <?php endforeach ?>
   ]});

Note that you may need to change some details to match your specific needs. Let me know if that gets you on the right track, or if you have any other questions!

Thanks,

Hi nmsinc

is their a means to keep the name in the search box and pass the value upon submission?

Could you explain this in a bit more detail? E.g. what is the current behaviour, and how would you like it to change?

Also, payment is not necessary, but your support is appreciated! You can always consider making a donation the next time you upgrade CMSB :) (https://www.interactivetools.com/upgrade/)

Thanks,

Once the selection is made from the autofill script the box shows the value of the record a not the autofill label text!!

Hi nmsinc,

Oh yes, I see now what you're talking about. I think there is a way to do something like how you want, but it's rather complex with this sort of autocomplete. It actually sounds like what you want is closer to a select box than a text field. I would recommend looking at using a select dropdown with the Select2 plugin (https://select2.org/). A select dropdown will let you use the value:label combination how you're wanting here, and the Select2 plugin adds some type-to-search functionality.

I hope that points you in the right direction; let me know if you have any further questions!

Thanks,