- Can't Edit Single Portal Row Filemaker 1
- Can't Edit Single Portal Row Filemaker Server
- Can't Edit Single Portal Row Filemaker 10
How do I determine the portal row number when dragging a document into a container field in FileMaker? Dragging a document into a container field doesn't change focus, so Get(ActivePortalRowNumber).
I forgot to say, I can do this if I copy the field, but is thereanother way?ThanksI have MacOS X and FMP 8.I have table one with two fields: onePK and oneFK.I have table two with two fields: twoPK and twoFK.I know that if I have a portal in table one and make the relationshipto 'Allow creation of record.' Then with the help of the portal acopy of onePK goes onto twoPK in table two.My problem is, can you do this without a portal? I have tried the'insert calculated results' and it will not copy onePK onto twoPK intable two from table one.
Basically the relationship is there, butthe portal is not to do the copying for me.-This list is a free service of OmniPilot Software, Inc.Search the list archives:Manage your subscription. I am not sure what is the best way to do this because I am pretty new to FM8but here is one way that works for me:Create a 'global' field and set the desired relationship value with ascript.
(This is how you are going to pass the related value to the othertable witout using a portal.) Next, have the script create a new record inthe target table and define your related field to do a lookup from theglobal field that you just set at the beginning of the script.Here is a working sample that you can download:on 6/3/06 2:11 AM, Francisco Romero wrote. I forgot to say, I can do this if I copy the field, but is there another way? Thanks I have MacOS X and FMP 8. I have table one with two fields: onePK and oneFK. I have table two with two fields: twoPK and twoFK. I know that if I have a portal in table one and make the relationship to 'Allow creation of record.'
Then with the help of the portal a copy of onePK goes onto twoPK in table two. My problem is, can you do this without a portal? I have tried the 'insert calculated results' and it will not copy onePK onto twoPK in table two from table one. Basically the relationship is there, but the portal is not to do the copying for me.-This list is a free service of OmniPilot Software, Inc.Search the list archives:Manage your subscription. I have MacOS X and FMP 8.
I have table one with two fields: onePK and oneFK. I have table two with two fields: twoPK and twoFK. I know that if I have a portal in table one and make the relationship to 'Allow creation of record.' Then with the help of the portal a copy of onePK goes onto twoPK in table two. My problem is, can you do this without a portal?
I have tried the 'insert calculated results' and it will not copy onePK onto twoPK in table two from table one. Basically the relationship is there, but the portal is not to do the copying for me.In FM8 you can use variables; you'have a script likeSet Variable ($ID, tableone::onePK)Go to Layout ( a layout of table two)New recordSet field (tabletwo::twoFK; $ID)Go back to original layoutA commentIn general table one should not have any foreign key, since - bydefinition - it is a master table; in table two the value of twoPKshould be unique, a serial number or the like, and should not deriveanyhow from table oneCiaoG. PupitaCertified FileMaker 7 DeveloperFSA Associate-This list is a free service of OmniPilot Software, Inc.Search the list archives:Manage your subscription. I am not sure what is the best way to do this because I am pretty new to FM8 but here is one way that works for me: Create a 'global' field and set the desired relationship value with a script. I am not sure what is the best way to do this because I am pretty new to FM8 but here is one way that works for me: Create a 'global' field and set the desired relationship value with a script.
Can't Edit Single Portal Row Filemaker 1
(This is how you are going to pass the related value to the other table witout using a portal.) Next, have the script create a new record in the target table and define your related field to do a lookup from the global field that you just set at the beginning of the script. Here is a working sample that you can download: No, that file is not an example of the technique you just described. The table twoPK you defined is an auto-enter calc that can't work - and it doesn't work, you are overwriting it with your script.Bruce,The file does work as he described. What may be confusing you is his use of PK and FK terminology; when I first looked at his example, I also was puzzled by the setting of TABLETWO::twoFK to the value 'new record no portal'.Of course, this is not the method experienced FMP developers would use to create a related record. Most experienced users would use a method similar to that described by Giuseppe Pupita.Regards,Jason L. DeLoozeAnnapolis, MD USA410-626-7415AIM: Jason L DeLooze-This list is a free service of OmniPilot Software, Inc.Search the list archives:Manage your subscription.
In FM8 you can use variables; you'have a script like Set Variable ($ID, tableone::onePK) Go to Layout ( a layout of table two) New record Set field (tabletwo::twoFK; $ID) Go back to original layout A comment In general table one should not have any foreign key, since - by definition - it is a master table; in table two the value of twoPK should be unique, a serial number or the like, and should not derive anyhow from table one-This list is a free service of OmniPilot Software, Inc.Search the list archives:Manage your subscription. So how would the experienced user modify the script so it navigates to newlycreated record at the bottom of the portal? Let's assume that there aremultiple portals on the same layout.I would like to see the last record created if there is a long list of itemsin the portal row but I do not want the script to insert the flashing textentry cursor into any of the visible fields.
I tried to insert a 'go to lastportal row' step at the end of the script but it is going past the last rowand it is also insert the flashing text cursor into the field.Should the script track the count of portal rows and go to the last recordby the calculation results, or is there a faster and more direct way to dothis?on 6/3/06 9:17 AM, Jason L. DeLooze wrote: Of course, this is not the method experienced FMP developers would use to create a related record. Most experienced users would use a method similar to that described by Giuseppe Pupita.-This list is a free service of OmniPilot Software, Inc.Search the list archives:Manage your subscription. So how would the experienced user modify the script so it navigates to newly created record at the bottom of the portal? Let's assume that there are multiple portals on the same layout. I would like to see the last record created if there is a long list of items in the portal row but I do not want the script to insert the flashing text entry cursor into any of the visible fields.
I tried to insert a 'go to last portal row' step at the end of the script but it is going past the last row and it is also insert the flashing text cursor into the field. Should the script track the count of portal rows and go to the last record by the calculation results, or is there a faster and more direct way to do this?Turn off 'Allow creation of records in this table via thisrelationship.' Then your Go To Portal Row (Last) will go to the newlycreated one (assuming that whatever sort is in use puts it there).In order to guarantee that it goes to the right portal, you can go toa field in the TO that the the portal is using first.-Jonathan Fletcher-This list is a free service of OmniPilot Software, Inc.Search the list archives:Manage your subscription.
Hi Steve,I looked at your v1b example. My responses are mixed within your post.On 6/3/06 at 14:19 -0500, Steve Penn wrote: So how would the experienced user modify the script so it navigates to newly created record at the bottom of the portal? Let's assume that there are multiple portals on the same layout.First one needs to set the portal focus, especially if there are multiple portals on the layout. We set the portal focus by going to a field in the portal. Thus,Go to Field TABLETWO::twoFKOnce we have the portal focus, we then go to the portal row we want to select. Thus,Go to Portal Row Select; LastWe use the 'Select' option to highlight the entire portal row.and.
deselect the portal row field we had previously used when we set the portal focus; that is, when we used 'Go to Field TABLETWO::twpFK'. I would like to see the last record created if there is a long list of items in the portal row but I do not want the script to insert the flashing text entry cursor into any of the visible fields. I tried to insert a 'go to last portal row' step at the end of the script but it is going past the last row and it is also insert the flashing text cursor into the field.For the portal in your sample file (v1b), the relationship on which the portal is based is set to 'Allow creation of records.' , which causes the portal to have an empty bottom (last) row for the creation of new records. However, we do not need to allow related record creation via the portal so we can get rid of this empty bottom row if we disable the 'Allow creation of records.' On the other hand, if you still want to be able to create related records via the portal (in other words, you want that empty row), then we need to remember that extra row is present in the portal and move back one portal row. Thus,Go to Portal Row Select; Previous Should the script track the count of portal rows and go to the last record by the calculation results, or is there a faster and more direct way to do this?I explained what was happening above; why you were going the the 'empty last row' instead of the new related record in the 'next to the last row'.
Either disable 'Allow creation of record.' On 6/3/06 at 6:55 -0700, Bruce Robertson wrote: I am not sure what is the best way to do this because I am pretty new to FM8 but here is one way that works for me: Create a 'global' field and set the desired relationship value with a script. (This is how you are going to pass the related value to the other table witout using a portal.) Next, have the script create a new record in the target table and define your related field to do a lookup from the global field that you just set at the beginning of the script. Here is a working sample that you can download: No, that file is not an example of the technique you just described. The table twoPK you defined is an auto-enter calc that can't work - and it doesn't work, you are overwriting it with your script. Bruce, The file does work as he described.
Can't Edit Single Portal Row Filemaker Server
What may be confusing you is his use of PK and FK terminology; when I first looked at his example, I also was puzzled by the setting of TABLETWO::twoFK to the value 'new record no portal'. Of course, this is not the method experienced FMP developers would use to create a related record. Most experienced users would use a method similar to that described by Giuseppe Pupita.No, it doesn't. It uses an auto-enter field but then just overwrites thefield. So the auto-enter is not used for anything.-This list is a free service of OmniPilot Software, Inc.Search the list archives:Manage your subscription.
Thanks but probably need to be clearer. I tried that and it stays in same layout (could edit the row in the portal) but want to (and am creating new window). Then going to related record gives me first row not current one in that list no matter how I script it. I am in the 'owners' table with a portal of related animal records. Larry - the Go To Related Record script stays has options in it to specify all the details that you need. I think the 'Show Only Related' options you are referring to in comment ID: 40124135 are options for creating a Value List and not what you want to be looking at.Use the Go To Related Record (GTRR) script step and you can specify the relationship to use, which would be the same one being used by the portal, the layout to 'Go To' - a layout based on the animal table, and whether or not to open a new Window. If you open a new window, you can then specify the title, size, and location of the window.
Can't Edit Single Portal Row Filemaker 10
You script is trying to do all the new window pieces first and so you loose which record to go from. Just use the GTRR step and fill out the options that I mentioned. In the screen shots above, I'm using a relationship from the Contacts table to Individuals, similar to your Owners and Animals. When the user clicks the GTRR button in the portal, it uses the ContactIndiv relationship to go to the related record in Individuals. It creates a new Window based using the 'Individual' layout and shows only the related record. In other words, if someone has multiple animals, the new window will show a found set of their animals with the one the clicked on in the portal being the currently active record.
You can't created nested portals (portal within a portal) but there are other ways to display or access related (grandchild) records/data. Post your new question being as explicit as you can (defining the question is a large part of what I do when trying to answer). Inluding screen shots or sample files is always helpful.In the Window options dialog above, I used all the options, including setting the name of the window, the exact size of the window and in the last two fields, telling it to offset 70 pixels right and and 70 pixels down from the starting window. If you don't set any of those, you'll get a new window, exactly the same size as the starting window and exactly on top of the starting window.