Mark Johnson Posted August 28, 2008 Share Posted August 28, 2008 I have a portal that pulls records correctly from another table with a field in that portal that has a calculation for Get (PortalRowNumber. So its basically like this: FieldName = Get (PortalRowNumber. My FieldName is just a calculation with the get function in it is all. The issue is when i go into browse mode, all it shows in that field for every record that is listed in that portal is 0 for the portal row number even if i have 7 records in that portal. They still all show 0 for the portal row number. Can anyone tell me what could be the problem? The relationship is correct and everything else works but the portal row number. Link to comment Share on other sites More sharing options...
Raybaudi Posted August 28, 2008 Share Posted August 28, 2008 What's your need for such field ? Link to comment Share on other sites More sharing options...
Mark Johnson Posted August 28, 2008 Author Share Posted August 28, 2008 Well the portal row is for a song playlist and i have the portal rows with a button to move the song up or down in the portal rows for the song i want to play first or if i want to arrange the songs in a different play order but i want the numbers so when i print the list i have the songs numbered on the print out for one but also just to keep track so i can just look at the row and say i have 4 songs and not have to go through the long list and count them physically. Link to comment Share on other sites More sharing options...
Raybaudi Posted August 28, 2008 Share Posted August 28, 2008 ...so i can just look at the row and say i have 4 songs and not have to go through the long list and count them physically. While in Layout Mode, place this: @@ with the text tool into the portal row. Link to comment Share on other sites More sharing options...
Vaughan Posted August 28, 2008 Share Posted August 28, 2008 The calc field with the Get( PRN ) function needs to be unstored. That said, Daniele's advice is good. Vaughan --------------------- Mi dispiace per il mio Italiano Link to comment Share on other sites More sharing options...
comment Posted August 29, 2008 Share Posted August 29, 2008 The calc field with the Get( PRN ) function needs to be unstored. That won't change much. Get(PortalRowNumber) returns the number of the currently selected portal row. When no portal row is selected, it returns 0. The calculation that numbers portal rows sequentially is Get ( RecordNumber ) - and "@@" is the 'Record Number Symbol'. Link to comment Share on other sites More sharing options...
Mark Johnson Posted August 29, 2008 Author Share Posted August 29, 2008 The double @@ symbol's worked great. Thats exactly what i was looking for. Something that can number the rows and be printed and not have to worry about physically trying to change the numbers or anything. thanks for all your help everyone. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5718 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