Sort record influence records

[Dani Rubenstein]

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

[Dani Rubenstein]

Help please.

[LaRetta]

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

[Dani Rubenstein]

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

Thank You

Demo.fmp12.zip

[LaRetta]

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.