Bigger or equal…

If Noms = Colonne14 then why not just use Colonne14? With troubleshooting you need to go back to the simplest form. Verify that you using the raw data and not other formula fields. Maybe create a new view with just the fields you need so you can see all relevent data or arrange the columns so they are all close to each other.

What did you change? Just change whatever you just did back.

You made Noms(colonne14) = 0. So what do you think would happen when you did that? Just change everything back.

 

I was talking about changing the Formule doublons Noms, but maybe you shouldn't change anything. I don't seem to be helping much. Maybe someone else can see something that I am missing.

 

In my simple DB it works: the third column shows how many times the person's name appear. Suzan shows up 3 times so Duplicate appears. SeoJung only shows up once so it is empty. The record with no name shows up as empty.

Maybe you can create a new DB with just a few records and try out the formula again. Then you can troubleshoot the larger db. Good luck.

Re-reading my last comment and I am embarrassed that I wrote it. I am very sorry for it. you deserve to be treated with dignity. 

Hi All

 

I'm not so sure about having select statements in a formula field and what the conditions are that trigger them to be re-evaluated. It could be that on first creating the formula field and showing it in the table view all of the records are showing their correct values but maybe you can then remove the duplicates and still have the remaining one record showing as duplicate.

 

Would it be better to have the code in a button and loop through all the records. It would update a text field instead of a formula field. I would also amend the code to show one master record and have additional ones as duplicate records per name.

 

Regards John

If you text field is called isDuplicate then this will work

 

let a := "";
for b in (select 'Oiseaux famille genres espéces') order by 'Premier mot' do
if a = b.'Premier mot' then
b.(isDuplicate := "Duplicate")
else
b.(isDuplicate := "Main")
end;
a := b.'Premier mot'
end

 

Don't forget to re run the code after you have done some tidying up

Hi

 

Your previous method used a formula field to calculate if the record is duplicate or not.  My method uses a text field to caputure whether your record is duplicate or not and you can call your new text field whatever you want to call it, I have used the name isDuplicate. You can see from my code that it is checking 'Permier mot" from the line

 

if a = b.'Premier mot' then

 

and updatiing the text field I have called isDuplicate here

 

b.(isDuplicate := "Duplicate")

 

or here

 

b.(isDuplicate := "Main")

 

the sign = is checking an equality, does this equal that wheras the sign := assigns the value shown to the right of the sign to a variable or field to the left of the sign 

 

let's run through what my code is doing. The first line sets a variable to a blank value not found in Permiere mot. The next line says lets run through every record in your table, sorted by Premiere mot so that they will be evaluated in that order. The next line asks if the variable has the same value as the first record. If it does then isDuplicate is set to "Duplicate" and if it doesn't then set isDuplicate to "Main" (it's the first time we have come across this name). Now we set the variable a to this name and go back to the table and run the same process with the next record. In you screenshot above this would translate to

 

a = "". Does "" equal Accentur? No, then set isDuplicate to "Main" and set a to Accentur.

a = Accetur.  Does Accentur equal Agrobate? No, then set isDuplicate to "Main" and set a to Agrobate

a = Agrobate. Does Agrobate equal Aigle? No, then set isDuplicate to "Main" and set a to Aigle

a = Aigle. Does Aigle equal Aigrette? No, then set isDuplicate to "Main" and set a to Aigrette

a = Aigrette. Does Aigrette equal Aigrette? Yes, then set isDuplicate to "Duplicate" and set a to Aigrette

etc

 

I hope that makes sense.

 

Regards John

Yes you are right , "si" must be "if" - "alors" must be "then" - "sinon" must be "else" - "fin" must be "end".

The code must always be in Ninoxlanguage (Anglais).

My code goes in a button not a formula field. isDuplicate is a text field. Lots of little miastakes in your code like a space between b, and 'Premier mot'  and a missing single quote at the end on the last but one line. If you just copy and paste my code I think it will work. But put it in a button. It's designed to run just once.