mmonsalveg Posted May 15, 2012 Posted May 15, 2012 Hello , i have POrders layout with some repeating fields, now when i try to start the script to copy some fields to a related layout , why the script only copies the first row of the field? im doing something wrong? here i attached you the sample, thanks for you help POrders.fp7
mr_vodka Posted May 15, 2012 Posted May 15, 2012 I am unsure about what you are asking but here are two things. 1. You can grab a repetition of a field by using GetRepetition(repeatingField;number) 2. You shouldn't be using repeating fields for something like this. Use a related table instead. You can use a portal to display the related records.
No_access Posted May 15, 2012 Posted May 15, 2012 I would not do a PO system this way, I would create a table for the line items and access them from their.. however if you want to do it your way, you need to add to your script set field[production::total;POrders:total] you need one of these for each repetion ie... set field[production::total[2];POrders:total[2]] set field[production::total[3];POrders:total[3]] ... etc.... or you can use a loop to set them all as variables whichever is easiest for you. hope this helps..
mmonsalveg Posted May 17, 2012 Author Posted May 17, 2012 Hello , thanks for all your reply , it works as FMP12 says. Actually is not a PO solution , its a manufacturing order that only accepts 3 colors, i choose repeating fields instead a portal just to prevent users to create new rows.
eos Posted May 17, 2012 Posted May 17, 2012 […] that only accepts 3 colors, i choose repeating fields instead a portal just to prevent users to create new rows. I also recommend using a child table. When you define a relationship for the child table and deselect the option “Allow creation of records via this relationship”, you can set up a portal that has no empty last portal row, which prevents your users from creating new child records, i.e. portal rows.
Recommended Posts
This topic is 4574 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now