2. PHPRunner General questions
  3. ajax and dependant lookups
This topic is locked

ajax and dependant lookups

 		9/25/2007 1:11:51 PM
PHPRunner General questions
J
 jim9 author

Right now the dependant lookups are working great with no problem. However a question.

Lets say in the first box you do your lookup, and the other boxes are filled, is there a way to drag the mouse over the box select the text, delete it and write in a temp value thats not in the lookup table? A good example would be -- You lookup a customer id in an ajax box, and below this box the address and phone fields are auto filled. THIS WORKS FINE NOW. However, what if after looking up the customer id, he or she wants it shipped to a different address this time only. Is there a way to do the lookup the normal way, but then manually over write the address and phone fields for this record only, since the customer wants it sent to a temp address for this shipment only. This is a common thing when shipping out orders. Even if you can show me how to manually edit the code for something like this, it would be appreciated.
J
 		Jane 9/26/2007

Jim,
To add new values to the dropdown boxes use Add new values on the fly option on the "Edit as" settings dialog on the Visual Editor tab. This option works with Lookup wizard with edit box with Ajax popup option together.
J
 		jim9 author 9/26/2007

But what if these values are to be temp values, and I want them stored in the current table, but not stored in the "LOOKUP" table? The use this address once only is a good example. If the customer has a regular ship to address stored in the lookup table, you'd fill fields with that. However, if the customer is visiting their aunt Bell, and says ship to Aunt Bell's address this one time only, then you would lookup the regular shipto but would want to over write the address, city, and town fields for this one record. But you wouldn't want in in the lookup table as this customers shipto address.

I know about adding on the fly, but this stores the info inthe lookup table also, and that isn't what I'm after.

Jim,

To add new values to the dropdown boxes use Add new values on the fly option on the "Edit as" settings dialog on the Visual Editor tab. This option works with Lookup wizard with edit box with Ajax popup option together.
J
 		jim9 author 9/26/2007

Or even a way to add a button to enter a temp address that could take you to another screen to override the values. Anything but storing only temp info in a main lookup table.
J
 		Jane 9/27/2007

Hi,
you can do the following:

  • add temp address using Add new values on the fly option,
  • then check entered values in the Before record added event on the Events tab and remove temp addresses from the lookup table.