Hi there,

I have a question; i need an advanced counter. I will try to explain my goal. The one who gets the final code gets a reward for sure!

The form:
The form has besides normal fields also a dropdown. In that dropdown are some companys; lets say:
Company A, Company B, and Company C. In the dropdown i said: 300|Company A, 301|Copmany B, 302|Copmany C

When i submit the form, in my table i see instead of Copmany A => 300. etc.

What I want:
Every submission has its own special number / ID with the company number before it.

Example:
Person 1 submits Company A; He gets ID - > 300-001
Person 2 submits Company A; He gets ID - > 300-002
Person 3 submits Company A; He gets ID - > 300-003
Person 4 submits Company B; He gets ID - > 301-001
Person 5 submits Company B; He gets ID - > 301-002
Person 6 submits Company C; He gets ID - > 302-001
Person 7 submits Company A; He gets ID - > 300-004 (its the forth person who submits company a).

Has anyone idea how to get it? (remember: the one with the correct code gets rewarded).

Field names:

Company dropdown - > Bedrijf
Special ID - > SpeciaalID
FormID - > 8

Thanks in Advanced!

HRR