Newbies roger111 0 Posted November 26, 2020 Newbies Share Posted November 26, 2020 Hi everyone, looking for an assist. I have related tables, and use a portal to display records. I would like those records to be numbered, simply 1 through whatever. I can't figure out how to get this done. Can someone help? Thank you! Roger Link to post Share on other sites
comment 1,817 Posted November 26, 2020 Share Posted November 26, 2020 Simply place the Record Number Symbol in the first portal row: https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/inserting-variables-on-layout.html Link to post Share on other sites
Newbies roger111 0 Posted November 26, 2020 Author Newbies Share Posted November 26, 2020 Thank you, comment! I'll try it right away. And thank you for the specific reference. The problem I often have when looking at these instructions is that I don't speak SQL or database, so I often don't recognize the answer even when the answer is staring me in the face. I'm just a single-user making a database for my own purpose (in this case, to manage a large music collection). I've managed to build a solution for myself, and just want to improve on what I have. Thank you for taking the time to answer. Happy Thanksgiving, should you be in the States. Best regards, Roger Link to post Share on other sites
bruceR 164 Posted November 26, 2020 Share Posted November 26, 2020 While comment's suggestion works, I experience a few problems with it. Consequently, I always add a calculation field to my tables, and make it unstored, get( recordNumber). See attached example file and screenshots. The advantage of using a layout variable is that you don't need to modify the field definitions. The disadvantage, in my experience, is that any time you touch the formatting of the variable, it resizes itself. SimpleRecNum.fmp12 Link to post Share on other sites
Newbies roger111 0 Posted November 29, 2020 Author Newbies Share Posted November 29, 2020 Thank you, Bruce, I did get comment's suggestion to work, but I'll try yours, too. A related question: can I use the get( recordNumber) function to somehow provide a count of certain records on a page? Say for instance that I want a page of statistics showing how many records in a certain field start with the letter A, the letter B, and so on. I'm learning by doing, essentially, and I appreciate the generous help of the people on this forum. Best to you and stay healthy. Link to post Share on other sites
Recommended Posts
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