By cat traveller
on a file accessed via filemaker Go 17, I am using a scripted navigation to move records up and down in a portal that is inside a popover.
This has worked in filemaker 12 like a charm and also works on a filemaker client. The records smoothly move up and down the list.
However in Filemaker Go, the portal follows every move of the script as if it is not aware of the freeze portal.
EG the down button is to move the record one record further down inside the filtered and sorted portal (like so)
This is the script.
- freeze window and go to portal
- go to first line of portal and loop through the portal until I hit the record to move
- go to next line and give the position field the value of my record to be moved
- go to line above and give the position field the value of my record +1
- commit record and refresh portal via an x join
- go to last line of the portal
- go to the line of position of my record to be moved.
Would anyone be aware of this issue or know a workaround to stop the portal from flickering?
Thanks so much
I have a drop down in a portal, how do i filter the drop down box to only display the record relating the record in focus on the active layout where the portal is inserted?
example: I have a customer selected in my customer layout, the customer has several products related to that customer. when I click on the drop down list in the portal, I only want to see the products for that specific customer. The drop down is in the warranty portal, products are saved in the product table with a reference to the customer.
Please could you assist?
i have 3 Tables Property , Units , Tenant.
Each property has many units , Each unit has one tenant active but may have many inactive tenants from previous years.
All working fine BUT.....
i would need to show a table in the property layout of the units and each one only with its active tenant.
The portal is based on the units table.
However the tenant just show up the tenant that was first input to the unit.
My question is , how could i get that only the active tenant should show to the unit?
i would really appreciate it someone could guide me on this.
Wondering whether this is one of Filemakers limitation and/or there are any ways round it.
i have a portal which displays my related records to a customer . These records are split down to two sections (Two options) i had created a slider that on slide 1 it displays option 1 and on slide two option two.
However the slider only seams to show up on the top portal row.
i would appreciate if anyone could explain me if this is not possible or something was just set out wrong.
I know I've done this before, but can't find an example of the functionality in my archives and can't seem to work out how to do it again.
I've got two tables: PERSONS and CONNECTIONS. PERSONS has an `id` field and CONNECTIONS has `person_1_id` and `person_2_id`. There's a relationship from PERSONS to CONNECTIONS with `id` = `person_1_id` and from CONNECTIONS to another TO into PERSONS, connections_PERSONS, with `person_2_id` = `id`, but these relationships may need to change to make this work.
On a layout with a context of PERSONS, I need a portal into CONNECTIONS that shows the names of the person on the other side of the relationship. So if Bill and Ted are connected, when viewing Bill's record I see Ted in the portal and when viewing Ted's record I see Bil's record.
Who Viewed the Topic