Validate Custom Text Field

[SBarnes]

Is there a way to add validation to a custom field on a debtor for instance if the custom field was a phone number where it was required to start with +61 or that the field contained the necessary elements to be an email address?

[pricerc]

Is there a way to add validation to a custom field on a debtor for instance if the custom field was a phone number where it was required to start with +61 or that the field contained the necessary elements to be an email address?

yes.

[SBarnes]

Which is?

[Scott.Pearce]

lol

[Scott.Pearce]

I think Mike has an incoming post with some possibilities...

[Mike.Sheen]

Is there a way to add validation to a custom field on a debtor for instance if the custom field was a phone number where it was required to start with +61 or that the field contained the necessary elements to be an email address?

You can use the ErrorText property of the grid cell to display an error indicator with a tooltip indicating the problem:

Code: Select all

grid.ActiveSheet.Cells(Row, grid.ActiveSheet.GetColumnFromTag(null, "RemitNo").Index).ErrorText = "This is my error";

You can do this within the PropertyChanged handler of the custom field values collection of the object - you'll just need to iterate the grid row by row to find the right row with the custom field name or id corresponding to the one in the event parameters.

You can then also add a client cancelled exception on the Savestart event of the business logic to cancel saving if any custom field value is not expected / valid.

You could also add edit masks to the grid cell - to force things like numeric only input - but I'm not a huge fan of that approach - I prefer to display an error indicator instead.

[pricerc]

https://forums.jiwa.com.au/viewtopic.php?f=26&t=1083&p=4143&hilit=validate+custom#p4143

?

[SBarnes]

Yeah well when you turn 50 and the short term memory start to go my bad.

Thanks for the reminder and suggestions.

[pricerc]

after reading Douglas Adams, one appreciates the importance of asking the right question....

once or twice a month, I do a pub quiz on a Tuesday night with my brother and sister. About the only time I see them, mostly.

The number of times I've wanted to answer "Yes" to a question like "Was the Queen crowned in 1952 or 1953?".... We'd win most nights

[Mike.Sheen]

I do a pub quiz on a Tuesday night

I thought smartphones and the internet kills quiz nights... do they hold it in a giant faraday cage?