Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Addinsell
Addinsell
410
1
0
Joined: Tue Jun 30 08:38:45 UTC 2020
Follow
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
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
I also modified in the formula "isduplicate" the name of the field > "isDuplicate"
Addinsell
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Sorry : "3" not "6" !
Addinsell
Addinsell
2 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
Addinsell
2 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
Addinsell
2 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
Addinsell
2 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
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Addinsell
Addinsell
2 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
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Addinsell
Addinsell
2 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
Addinsell
2 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
Addinsell
2 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
Addinsell
2 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
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Dindon sauvage and Megapode de Reinwardt > number 1
Addinsell
Addinsell
2 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
Addinsell
2 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
Addinsell
2 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
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
On another base :
Addinsell
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Well I tried the formula : "Duplicate" is still everywhere. IE the Solitaires…
Addinsell
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
It's ok. I understood… I'll tell you about the result.
Addinsell
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
It's ok. I understood… I'll tell you about the result.
Addinsell
Addinsell
2 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
Addinsell
2 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
Addinsell
2 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Addinsell
Addinsell
2 yrs ago
Get help
Reported - view
1
3
4
5
6
7
17
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics