Repeating Field Calculation
I have 2 fields with 5 reps each.
Field Name: bidtype_number (5 reps)
Field Name: bidtype_date (5 reps)
I have entered "1" into bidtype_number and the below script returns the date in bidtype_date
If [bid cost::bidtype_number = "1"]
Insert Current Date [Select; bid cost::bidtype_date]
Script Trigger = OnObjectValidate and i have attached it to this script.
I would like to make this work for the next 4 repeating fields. How do i make the data in the second repetition of bidtype_number result as a date in the second repetition of bidtype_date?
It should look something like this...
Bid Number Bid Date