Calculations break when Creating New Records from Related Table
I used the script below to create new records from one table [Production] into another [NEW].
Go to Layout ["Weeks" (NEW)]
Show All Records
Delete All Records [No Dialog]
Go to Layout ["Production" (Production)]
Sort Records [Restore;no dialog]
Go to Record/Request/Page [First]
If [Production::Mark ≠ "x"]
Set Field [NEW::Unique; Production::Unique]
Go to Record/Request/Page [Next; Exit after last]
The tables are related by
This works and brings in the correct number of records but the calculations that were working when I imported records no longer work when I use a script to create the records instead. Is there a way to have the script copy over the field information when it creates the new record rather needing to use calculations?
I can use calculations to fill in the Name and Week fields but the calculations to fill in Shipping and Availability, which are based on the week, only fill in information for the first week. Any thoughts would be helpful. I have tried changing the relationships as well as the calculations themselves but nothing I've tried seems to work.