Hello to all

I Have a layout that is sorted by CIty's in the sub summery i what to have a filed that will influence records that are onder them.

Can It be done.

i did a the prblem that i see is if a have a global filed in the i put in the sub summery and when i enter what i want to that filed and run i script it work fine the prblem that I have is that the user will see the data in the global filed in all the sub summery lines.

Thank You

Dani

Help please.

Your request is unclear. We want to help. Please provide more information that uses complete sentences. :-)

Hi thank you here is a demo file the you can understand me.

Thank You

Demo.fmp12.zip

H Dani,

Here is simpler approach (no summary field needed). After sorting by City ...

Set Variable [ $priority ; Demo::Priority ]

Set Variable [ $city ; Demo::City ]

Loop

Exit Loop If [Demo::City ≠ $city ]

Set Field [ Demo::Priority ; $priority ]

Go To Record/Request/Page [ Next ; exit after last ]

End Loop

... attach this script as script trigger OnObjectModify to your pop-up Priority field which is not a global and that is fine - a global isn't needed here. It will use that first record as the template for the remaining records in that group. Let us know if this is not what you want.