Newbie web app developer: data validation

[phabio]

I've try with single and double..

[phabio]

Ok, I've create a simple APP, Javascript, based on SouthWind
I've a section, based on Orders table
I've created a index on customers table
Index on customerid tag customerid

on the customer formfield I've add a validation:
keylookup('southwind!customers', 'customerid', "'{}'", 'true', 'false')!='false'

this work on App Builder but not on Web Preview.

but work on app inspector if I put a value
keylookup('southwind!customers', 'customerid', "WILMK", 'true', 'false')!='false'

I've try with single and double quotes

it's impossible to save the edited records.

[yvonne.milne]

Hi Fabio,

There are too many quotes around the {}. It should be:

keylookup('southwind!customers', 'customerid', '{}', 'true', 'false')!='false'

Regards,

Yvonne

[phabio]

Can I use:
Lianja.evaluate("mylib::mylibproc('{}')") ?

[barrymavin]

Can I use:
Lianja.evaluate("mylib::mylibproc('{}')") ?

Fabio,

Tell me what you think {} is substituted for. Then maybe you can answer your own question.

[phabio]

Fabio,

Tell me what you think {} is substituted for. Then maybe you can answer your own question.

Hi Barry,
this is to use a custom validate code.
for example:
you're insert a sales order for cusromer "WILMK"; this code it's right.. but the customer are suspended cause have a not payed invoice..

[barrymavin]

Hi Barry,
this is to use a custom validate code.
for example:
you're insert a sales order for cusromer "WILMK"; this code it's right.. but the customer are suspended cause have a not payed invoice..

Yes I have a good idea what validation is used for.

What I was trying to explain to you is that Lianja.evaluate() has no clue what {} is.

When you specify {} in the validation expression for a formitem, the framework knows what formitem is associated with {} and it can then substitute the current input text value.

{} is primarily used to substitute the current value associated with a UI element. In certain cases e,g Data Mapping on the server it is used to substitute current table.column value.

[phabio]

Hi Yvonne,
your sample don't work on web preview.

[barrymavin]

Ok Fabio.

you need to double the single quotes around the {} as keylookup() is a built-in function that will proxy a call to keylookup on the server.

You are not enclosing {} in quotes to the server.

‘\’{}’\’

That should properly enclose the value substituted for {} and it will be sent as ‘WILMK’

[yvonne.milne]

Hi Yvonne,
your sample don't work on web preview.

Hi Fabio,

Yes, it does. Put it in the field's validation attribute as you said you were doing in your test App.

Regards,

Yvonne