2. PHPRunner General questions
  3. Can't add new values on the fly with Query
This topic is locked

Can't add new values on the fly with Query

 		3/10/2016 7:57:15 PM
PHPRunner General questions
J
 jwehner author

I'm trying to add a drop down from a custom SQL table view but I also want them to be able to add a custom/new field.
The view is referencing a table in another database with read only access.
I checked the box 'Allow to add new values on the fly' but it still doesn't
I'm running IIS w/php and PhpRunner Enterprise.
Any ideas?
Sergey Kornilov admin 3/11/2016

'Add new records on the fly' is the option that would allow you to add new records to the lookup table. Since you have a readonly access to lookup table this option won't work for you.
You can try to use 'Allow free input' option.
J
 		jwehner author 3/13/2016

Ok I understand the difference now. I tried the 'Allow free input' and the box changes to an edit field but there is no drop down option (i'm using the 'Edit box with Ajax popup' option))
Sergey Kornilov admin 3/14/2016

Yes, this is the way how it works. If you want to add new items by typing and cannot have a separate 'Add new item on the fly' screen - it must be an edit box. You cannot type in anything into a dropdown box.
J
 		jwehner author 3/15/2016

Thanks for the explanation. This is acceptable for my case. the only other thing I would like to do is change the size of the AJAX drop down predictive search. It's cutting off the text. Can this be changed?



Yes, this is the way how it works. If you want to add new items by typing and cannot have a separate 'Add new item on the fly' screen - it must be an edit box. You cannot type in anything into a dropdown box.