Choose field mode - add value from source or not

0

Hi Marcin,

the behavior /configuration itself wouldn't be changed but you could add a condition to the data source like

where IsExternal = 0

This way the data source would not return any values if "is external" is checked.

Best regards,
Daniel

I also thought about seceond filed type text to be use without source and show/hide one of field but it not ok idea when we are talking about it in grid - how to in one row hide column and in next show it?:)

I didn't found any way to "merge" a column yet.

If your external data source doesn't use a GUID as id, than you can make use of the fact, that values not part of the database use a GUID as an id. At least this was the case when I last checked it.
So you could check, whether the id is like a GUID and if it's like a GUID and "IsExternal" is false, than display an alert and clear the value using the "Form value changed" trigger. This should also work the other way around.
If the id field of the database is an integer or so you could probably test the Id of the picker field for length and if it contains a - character.

Best regards,
Daniel