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
John Halls
John_Halls
Somerset, England
718
111
1
Joined: Thu Feb 11 10:04:26 UTC 2021
Follow
My Posts
Latest Posts
Re: Search exact name…
Ah yes, you are right, I hadn't thought of that one. Tangara emeraude would indeed be included.
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Search exact name…
The like "Ara " part has a space in the quote, at the end. I had it working exactly as you desired for me.
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Search exact name…
The like "Ara " part has a space in the quote, at the end. I had it working exactly as you desired for me.
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Search exact name…
This works ="Ara" or like "Ara " or like " Ara" Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Not like "word"
Try not like "jaune" and not like "noir"
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Error in a script to find duplicates
How this happened I don't know, but we have two types of single quote going on ' ASCII code 39 is at the start of your table name ’ ASCII code 146 is at the end of your table name Make them both the…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Error in a script to find duplicates
Can you post a screenshot of the code
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Error in a script to find duplicates
Hi You are missing the select statement in line 2. On line 9 change No to Nom. You only need to put the table and field names in single quotes when they have spaces in them.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Error in a script to find duplicates
Sorry I missed that. I think Oiseaux famille genres espéces needs to be in single quotes 'Oiseaux famille genres espéces' whereever it's used, and Field has to be replaced with your field name that…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Error in a script to find duplicates
Strange but true I saw it remove the duplicates but then I couldn't do anything. Try the above which renames duplicates with 'xxx' and then bulk deletes them.
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Error in a script to find duplicates
How about let t := "";for i in (select Table) order by Field do if t = i.Field then i.(Field:= "xxx") else t := i.Field endend;delete (select Table)[Field = "xxx"] Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Error in a script to find duplicates
I had a go at this, changing text(i) to i.text in the two lines where it is used. It did work and removed duplicates in a small table but then hung and I had to quit out and come back in again,…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Copy Data from one for into another then open that new record
Hi Mel I think you need to change Phone:=a to i.Phone:=a for i in select Table1[Phone=null] do let a := i.fxTemp; i.Phone := aend Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Copy Data from one for into another then open that new record
The if statement can be taken out by tweaking the line before, so you end up with for i in select tableOne[Archive="Yes"] do let a := i.FieldA; let b := i.FieldB; let c := create tableTwo; c.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Formatting printing of forms
I've just had a play with the print section for the first time so someone correct me if I am wrong. It looks like fields are represented by {field}. You can change this to {if test then field end}
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Is it possible to have a filter expression for character count?
Yes you *can*, by creating a formula field with the code length('Field 1'). Show this as a column and filter for 17. I'd be looking for a better solution than this though.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Recors counting
That should have read 'automatically update as you add'
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Recors counting
Hi Francesco Try adding a formula field to TABLE A and use this formula count ( select 'TABLE B' ) It will update automatically as us add and delete records to TABLE B Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
1
23
24
25
26
27
28
29
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics