Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4574 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

Posted

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..

Posted

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.

Posted

[…] 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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.