REC NUMBER UPDATE

October 7, 20169 yr

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, 20169 yr by Dr.Gopala krishnam raju AMBATI

October 7, 20169 yr

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

October 7, 20169 yr

Author

:help: didnt get it sir ?

October 8, 20169 yr

Author

:help:

October 8, 20169 yr

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

October 9, 20169 yr

Author

i did same thing sir not working

October 9, 20169 yr

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.