Forum | Appery.io

Cheers Marina,
I tried that in test, here is the result, successful but no entries, there are over fifty companies in "newcastle upon tyne"

also cant use the above with select menu

1) Are you sure that there is a record NEWCASLTE UPON TYNE in DB in field Town?
Make a request with empty "where" parameter and check response. As we can see from the screenshot there is ALNWICK record in Town field. Try to send request with where code{"Town": "ALNWICK"}/code
Does this request work?

2) To use selected value in Select add JS in mapping codereturn '{"Town": "' + value + '"}';/code

Thank you Marina

{"Town": "ALNWICK"} works in test, but selectmenu will not allow entry of

{"Town": "ALNWICK"}

In value should be ALNWICK and this code codereturn '{"Town": "' + value + '"}';/code add in JS in mapping to request parameter where

As always Marina,
thx very much, works great!