REC NUMBER UPDATE

[Dr.Gopala krishnam raju AMBATI]

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

[doughemi]

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.

[Dr.Gopala krishnam raju AMBATI]

didnt get it sir ?

[Dr.Gopala krishnam raju AMBATI]

[dezkev]

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

[Dr.Gopala krishnam raju AMBATI]

i did same thing sir not working

[comment]

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.

[Dr.Gopala krishnam raju AMBATI]

COMMENT is the best