AnsweredAssumed Answered

Setting one Repeating Field to another

Question asked by user910 on Jun 24, 2017
Latest reply on Jun 25, 2017 by user910

I'm trying to copy an employee's default weekly schedule into a planned schedule using a script. The default data is in a 7-repetition field in an Employees table, and I want to copy it into a similar 7-repetition field in a related Schedules table. A straight SetField just copies the first repetition. I'll leave out the various other things I've tried. Are there magic words to do this in a single script step?

 

I'll note that questions about repeating fields tend to get replies saying that they're a bad idea anyway, but they can save us a lot of ridiculous repetition. FileMaker seems to fall way short of providing the vector operations repeating fields deserve.

Outcomes