Dr.Gopala krishnam raju AMBATI Posted October 7, 2016 Share Posted October 7, 2016 (edited) dear experts i made few records with calculating sno filed with Get(RecordNumber) when i am deleting particular record serial number are not updating serially and looking awkward sum1 please help me to rectify this problem please REC CHANGE.fmp12 Edited October 7, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
doughemi Posted October 7, 2016 Share Posted October 7, 2016 You can change sno to a calculated field (unstored calculation) instead of a text field with auto entered calculation. However, DO NOT do this if the field is used for any other purpose than a user display. If it changes with sort order or found set, it is useless as data. A serial number, to be valid, must never change. Never use a number derived from Get(RecordNumber) as a serial number. If sno is an abbreviation for serial number, I suggest you change the name to dno for display number, and do not under any circumstance use it as a serial number. 1 Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 7, 2016 Author Share Posted October 7, 2016 didnt get it sir ? Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 8, 2016 Author Share Posted October 8, 2016 Link to comment Share on other sites More sharing options...
dezkev Posted October 8, 2016 Share Posted October 8, 2016 hello, I think if you are going to delete records then there will be gaps in your serial numbers. I don't know how to solve this, sorry,. But I am sure it is doable, but pretty complicated. Maybe others can give an idea. What Doughemi is saying in his reply is : Make your serial number field a calculation field and use the Get(RecordNumber) function. Like this : Sno = Get(RecordNumber) [ file is calculated field with result set to be number]. Hope clear. rgds Kevin Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 9, 2016 Author Share Posted October 9, 2016 i did same thing sir not working Link to comment Share on other sites More sharing options...
comment Posted October 9, 2016 Share Posted October 9, 2016 19 hours ago, dezkev said: What Doughemi is saying in his reply is : Make your serial number field a calculation field and use the Get(RecordNumber) function. He is saying one more thing: On 10/07/2016 at 6:45 PM, doughemi said: You can change sno to a calculated field (unstored calculation) instead of a text field with auto entered calculation. And I am saying that you probably don't need such field at all: just insert the record number symbol onto the layout:http://www.filemaker.com/help/15/fmp/en/#page/FMP_Help%2Finserting-variables-on-layout.html Note that both methods will number the found set. Omitting a record will renumber the remaining records same as deleting a record would. And sorting the records will renumber them to reflect the new sort order. 1 Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 9, 2016 Author Share Posted October 9, 2016 COMMENT is the best Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2749 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