I have a text field that has information in it that I want it to automatically duplicate into another formula text field, is this possible? What ever data goes into the first text field get automatically duplicated into the second formula text field
Then the formula for the field called Field 2 which is a formula text field would be
The field choices for building a formula can be pulled in from a drop down list on the right side of the formula box.
[check in]=true, [request status] (shipped)
[check out]=true, [request status] (returned)
The default value is requested so that doesn't need a formula I don't think.
[check out]=true, "Returned",
[check in]=true, "Shipped", "Requested")
But in my mind you have a backwards idea of what check in and check out mean, so I think that you really want....
[check in]=true, "Returned",
[check out]=true, "Shipped", "Requested")
Like a library book, you check it out when you borrow it and check it back in when you return it. But maybe you have a different Terminology.
Note that an IF statement processes the tests in sequence and stops checking when it finds the first true condition, so if the first test is not true, then it tries the second test, and if that is also not true then in this case it just defaults to the "else" which is the "Requested"
The expression [Test Kit - Check In] on the left hand side of the operator "=" is of type text while the expression true on the right hand side is of type bool. The operator "=" cannot be used with these types of expressions.
I do not suggest that you keep the bar code fields as numeric field, if they are long numbers. I suggest treating them as text fields.
Trim([check in]) <>"", "Returned",
Trim([check out])<>"", "Shipped", "Requested")
If the fields are numeric
[check in]>0 , "Returned",
[check out] > 0, "Shipped", "Requested")
Try a Dynamic form rule though. I have not tested this but it should work.
When the record is saved
and ALL of the following:
[check out] not equal (blank) - ir just leave the field empty
[check in][ not equal (blank)\
[check in] not equal to the value in the field [check out]
Abort the save with message "Sorry, but the bar code checked out does not match the bar code checked in. Please resolve and then try again."
If you are saying that the items being scanned has three bar codes n it because the item is some kind of kit with three parts to it, then you should consider three separate scan fields to scan in, and three to scan out. Then we would need to beef up the formuals I suppose as you may not scan then in back to the same fields as when they were scanned out.
If, however, you still want to just use one field and also are prepared to ensure that the sequence of the scans out for that single input field matches the sequence of the scans in, then you could try to create two new fields called
[Trimmed scan in] and [Trimmed scans out] and put them on the form.
The formuals would be Trim([Check in])
and Trim ([check out])
Then use those field in your form rule. I'm thinking that somehow there are some invisible spaces getting into one of the fields that you are not seeing.. The Trim ( ) function will trim those out.
Fields are text:
Trim([check in1]) <>"", "Returned",
Trim([check out1])<>"", "Shipped", "Requested")
Now that I have three fields would the formula be something like this?
Trim([check in1]) <>"", "Returned",
Trim([check out1])<>"", "Shipped", "Requested",
Trim([check in2]) <>"", "Returned",
Trim([check out2])<>"", "Shipped", "Requested",
Trim([check in3]) <>"", "Returned",
Trim([check out3])<>"", "Shipped", "Requested")
You need to tell me in words what you want. never mind the code for now. So if they check out three scans and only two come back - what is your status? Also I still do not understand why there are three scans. Why cant each check in and check out be separate - why three cans on a single checkout. What if they don't return the third scanned item?