Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Addinsell

Addinsell

410
1
0

Joined: Tue Jun 30 08:38:45 UTC 2020

My Posts

Latest Posts

Re: Bigger or equal…
Thanks Steven Now I get the error "a column has not been find : isDuplicate on the line 4, column 18" "isDuplicate" is in fact the name of the field where I create the formula… It's impossible !…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
I also modified in the formula "isduplicate" the name of the field > "isDuplicate"
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Sorry : "3" not "6" !
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Thank you so much John. That is very clear now. I know a lot more about this kind of formula. Nevertheless I get always the same kind of error : "A column has not been find si on the line 6,…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
I tried with that hypothese : I get that error : "A column has not been find si on the line 3, column 3"
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Unless you speak about the "Duplicate 1° mot" column next to the column "Premier mot" ?
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Thank you John. Why do you ask "If you text field is called "is Duplicate" then this will work" ? As you can see on the capture, the column involved is "Premier mot" (first word).
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Hi Fred, Don't bother, you have been already so patient.Thanks again. Well I had a lot of duplicates : 1109 ! The app was very slow… I succeed in removing it. Now it is ok for that.…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
I changed as you say (Colonne14 and Noms) and now I have number 0 at each records ! How can I retrieve recover them ?
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
I may have an explanation. When I open the fields of one of the bases, very often I have a column number of the field in the formula and a name in the name field Here "Noms" in the name field and…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
There are not differents bases but differents views of the same table of a base.
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
There are the two formulas of the two differents bases One has "Nom", the other "Noms" let myV := Nom ; if myV := null then "empty" else if cnt(select 'Oiseaux famille genres espéces' where Nom =…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Dindon sauvage and Megapode de Reinwardt > number 1
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
With the new formule Souimanga has number 2 like all the others, except Dindon sauvage and Megapode de Reinwardt
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Hi Fred, You say : "The second image it looks like the formula is working as intended. There are duplicates there." Yes but where are the "non duplicate" ?
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
That one for the second base : let myV := Nom;if myV := null then "empty"else if cnt(select 'Oiseaux famille genres espéces' where Nom = myV) > 1 then "Duplicate" else null endend
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
On another base :
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Well I tried the formula : "Duplicate" is still everywhere. IE the Solitaires…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
It's ok. I understood… I'll tell you about the result.
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
It's ok. I understood… I'll tell you about the result.
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Thanks a lot Fred. About "unless"/"if not" what do you mean by "this has to be in English and has to be else". Else ?
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Thank you Steven, and John. Thank you Fred. Fred, your formula has some words in French. Maybe it will not work. I already had issues with that. I tried to manage it…but I need your help.…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view

1 3 4 5 6 7 17

Back to top

Overview

View all topics