moj6054 Posted February 12, 2012 Share Posted February 12, 2012 How can I display last record in portal? Link to comment Share on other sites More sharing options...
imoree Posted February 12, 2012 Share Posted February 12, 2012 Sorry, but this question is too vague in my opinion. - are you using a script, - are you going to another layout? Link to comment Share on other sites More sharing options...
moj6054 Posted February 12, 2012 Author Share Posted February 12, 2012 After I insert record and go to another record, When I back to this record, I see last record (last line). thank you, Link to comment Share on other sites More sharing options...
moj6054 Posted February 12, 2012 Author Share Posted February 12, 2012 Sorry, but this question is too vague in my opinion. - are you using a script, - are you going to another layout? After I insert record and go to another record, When I back to this record, I see last record (last line). thank you, Link to comment Share on other sites More sharing options...
Bailey Kessing Posted February 12, 2012 Share Posted February 12, 2012 Reverse sort the relationship will do the trick Link to comment Share on other sites More sharing options...
LaRetta Posted February 12, 2012 Share Posted February 12, 2012 I see last record (last line). See it where, moj6054? In the first row of the portal? In related fields placed directly onto the layout? If you ask for the 'last' related value via script? What determines whether the record is last? If you have a Creation Timestamp field and you want the last 'created' record then, as Bailey suggests, sort the relationship descending on Creation. Sorting the relationship will also sort the portal in that order unless you change the sort on the portal itself. So if you do not want to sort the relationship, you can still just sort the portal. :laugh2: Link to comment Share on other sites More sharing options...
moj6054 Posted February 13, 2012 Author Share Posted February 13, 2012 I mean, In Portal when you insert some record, when you got to next record , the last record hide in portal and when back, I need to scroll bar down to view last record, I need to see last record in portal when back. Link to comment Share on other sites More sharing options...
LaRetta Posted February 13, 2012 Share Posted February 13, 2012 If you always want to view the last record in a portal, you can create a script with: Go To Portal Row [ last ] Commit Records/Requests[ perform without dialog ] ... and attach it as a script trigger to the layout (Layouts > Layout Setup > Script triggers tab, as OnRecordLoad. You must also make sure that, in Portal setup, 'reset scroll bar' is unchecked. :^) 2 Link to comment Share on other sites More sharing options...
moj6054 Posted February 14, 2012 Author Share Posted February 14, 2012 thank you Link to comment Share on other sites More sharing options...
Pedroble Posted March 8, 2013 Share Posted March 8, 2013 If you always want to view the last record in a portal, you can create a script with: Go To Portal Row [ last ] Commit Records/Requests[ perform without dialog ] ... and attach it as a script trigger to the layout (Layouts > Layout Setup > Script triggers tab, as OnRecordLoad. You must also make sure that, in Portal setup, 'reset scroll bar' is unchecked. :^) Thank you - that is very useful. I have a file that has multiple tabs and sub-tabs, many with portals. The script trigger works for the main-tab but not the sub-tabs and causes a disturbance when clicking through their registers. Script triggering on the individual portals does not either. How can this to be worked? TIA Link to comment Share on other sites More sharing options...
LaRetta Posted March 8, 2013 Share Posted March 8, 2013 Name the portals themselves using Object name then Go To Object [ "that name" ] 1 Link to comment Share on other sites More sharing options...
Pedroble Posted March 8, 2013 Share Posted March 8, 2013 That works for the individual portals using 'OnObjectEnter' but I must activate the object manually to get to the last record. Link to comment Share on other sites More sharing options...
LaRetta Posted March 8, 2013 Share Posted March 8, 2013 Sorry I was unclear ... Go To Object [] PINS you to a portal then next step Go to Field[ yourField] will always work. If you do not pin to a portal first, and you have multiple tabs, then it can break in a variety of ways. I could create simple demo showing how easily it breaks on you if you wish but the idea is to pin it first then do whatever is necessary in your script such as going to the last row or going to the field. Link to comment Share on other sites More sharing options...
Pedroble Posted March 11, 2013 Share Posted March 11, 2013 Sorry about the time responding. I've been trying to figure out the 'Go to Field[yourField]' It doesn't seem to work whatever way I put it in the script. Only when I manually click inside the portal, does the register jump to the 'last row'. Link to comment Share on other sites More sharing options...
LaRetta Posted March 11, 2013 Share Posted March 11, 2013 I would suggest that you zip and attach your file if you can, to show the issue. Link to comment Share on other sites More sharing options...
Newbies Zain Posted June 3, 2013 Newbies Share Posted June 3, 2013 Dear All I have a similar query appreciate if any expert guides me, since I am very new to File maker, the scenario is. I have two tables “HRMaster table” with Current Position and “wages table” with position both of them are linked with relationship using primer key and working fine In the browsmode I have added HRMaster as main and wages as a portal. If I enter a new position in wages “position” it should change current position of HRmaster. If not it should retain its current position of HRMaster Appreciate your help Regards Zain Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3978 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 accountSign in
Already have an account? Sign in here.
Sign In Now