Field Validation in Form

Put this in Field's SerialNumber InputValidation:

FIELD SerialNumber:=SerialNumber;
found:=@DbLookup("":"NoCache";"";"byserialno";SerialNumber;1);
@If(@IsError(found);@Success;@Failure("used SerialNumber: "+SerialNumber))

'morning CRAK :-)

Sorry Zvonko, I haven't been online a lot today...

In your example... what if a user saves a document (new ser. no) and without any change save again....?
It triggers the @Failure!
That's where I started involving the doc id in the validation.

Sure! You are right :-)

;-))
Thanks!

Should I extend my proposal to your recommendation?
Now I mean when we are both here this small points are really not a question :-)

It could help Ram123 if he/she needs sample code. I've already described the solution in my comment, including the column description of the view.

You are right. For this little points has he/she enough to read :-)

Where has my bro gone that provides full service, no matter how small the amount of points is?

Any news on your job Zvo?

Whom are you talking about bro? :-)

There are big news, but better I tell you that on our line :(

Our bro.... what whas his name again....? The <|:-) -one!

ok.

:-)

Hello,

Sorry that i could not reply as i was on leave.

I am not getting the error message, its still saving duplicate entries.

My settings are as follows:

FORM
Form Name: EquipmentAsset
fieldName : SerialNumber (Type:Text, editable)

VIEW

View Name: Asset By SerialNo
View Selection Formula : SELECT Form = "EquipmentAsset"

Column 1:
ColumnTitle : Serial Number
formula: @Trim(x:y)
Sort: Ascending
Type :Standard
Show multiple values as seperate entities

Column 2:
ColumnTitle : Tyep
field: Type
Sort: None
Type :Standard

As you said i inserted a column between col1 & col2 and named it Unique ID (hidden) and gave the formula @Text(@DocumentUniqueID)

And in my form for the SerialNumber field gave the formula for Input Validation.When i entered a serial number which is present in the d/b it just saved.

I don't whats wrong, or where am i going worng?

Please add the validation formula as well...
If @DbLookup fails save is allowed, no matter the reason of the failure. Probable causes include: s/n wasn't found (some typo), or the entire view(name) wasn't found.

Hello buddy, hello Ram,

there are to much typos in your setting Ram.

Ok, let's change.

VIEW:
Add below the view name "Asset By SerialNo" into the field labeled Alias this name: byserialno

The first column has to be sorted (is already) but not a Formula then a Field should be the value for this Column:
SerialNumber

Insert a second column in this view and make it hidden.
You can make this column as last one in the view (append the column) and make it hidden. Important is only to have this additional column NUMBER correlate to your SerialNumber validation formula. So let us here assume you decide for the second Column.
Here is the Formula for the second column in your view:
@Text(@DocumentUniqueID)

Now the Form "EquipmentAsset"
The only thing you have to set in this Form is the InputValidation for the Field "SerialNumber".
Here is the InputValidation formula for the field "SerialNumber":
FIELD SerialNumber:=SerialNumber;
found:=@DbLookup("":"NoCache";"";"byserialno";SerialNumber;2);
@If(@IsError(found);@Success;found=@Text(@DocumentUniqueID);@Success;@Failure("used SerialNumber: "+SerialNumber))


That's all.

Good luck,
Zvonko

Thanks Zvonko,

Its working fine.

Rgds,
Ram123

Ok.

What about increasing the points and giving me an A+ :-)

What about an entry "for CRAK" with an even higher no. of points? After all: anyone could have come up with the A solution, but who came up with THE solution first?

your FIRST solution was for thirty, I am now bagging for more :-)
If you get hundred then I will get three times :-)

For running off with my solution???
I guess you'll then be offering me another 500 * "A" as redemption!?
;-))

Oh, come on. Do you really believe I would not be able to solve that problem???

For ***500*** you have to offer better tricks ;-)

I know you can... I know you would have... if/when the 2nd save-issue would occur.
But I did so first! So obviously the larger part of the score is mine.
;-P

Did you see CRAK? This 30 would not be enough, but the next one and I am jumping over you (except you get this 500 in advance :)

And when you arrive in the 1st column you start a 4th id right? Just to push me further down in the list.....
What a great friends I have here at EE!

(Do you think Ram waits for us to end this argument before assigning me the points?)

Who cares about thirty points! :-)

...but the arguing is so much fun!

That's why we are still in :-)

WE are....
I wonder if Ram is....
;-))

I have a form with a computed field created by joining three other fields (location, date, time) to create a appointmentref, the idea being that the same time slot at the same location can not be taken by more than one records.

I want to be able to ensure the field is unique by checking against a hidden view which lists all records sorted by appointmentref.

You should post that as a new question: draws attention of all other experts (not just the ones participating in this question).
However, if you use your appointmentref instead of the serialnumber, things should be exactly the same!
Have you thought of a way to detect overlapping appointments?
E.g. {Room 1@Jan 1, 12:00-13:00} vs. {Room 1@Jan 1, 12:30-13:30}