im looking for a calculated field, which takes a certain string out of an other field and adds a numeric value. This value should be ongoing depending on how many other entrys exist.
Let me try to explain this in detail:
I create a contract, this contract has
Field A : customer name or number
Example: Customer Smith
Field B (claculated field) which should be Field A with the addition of the contract number - 001
(in this case, the customer can have multiple contracts)
Example: Customer Smith - 001
When i create a new contract and field A is again this customer ,then field B should show me: Field A - 002
and so on.
Example: Customer Smith - 002
if it is a new entry and there is no 001 than this field should be the 001
i hope i could express my problem somehow clear.
thanks in advance