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
603
72
1
Joined: Thu Feb 11 10:04:26 UTC 2021
Follow
My Posts
Latest Posts
Re: Same words which should not be repeated…
Check for trailing spaces "Passeriforme" vs "Passeriforme " vs "Passeriforme " This would give three groups
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Multiple items from inventory used as one product
Hi Tom I'll get you to the point where you have added a KIt table and it's joins.Once we know you have that working we'll move on th the next stage. Add a table called Kit.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Search exact name…
You can search in the table view for *Ara* and this will give the same result. This means you can seach in a kanban view too.
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Search exact name…
Hi No need for a button. Just add this additional field Have it show in the list Then type your filter into this field And you have your desired filtered list Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Multiple items from inventory used as one product
I'll put something together over the weekend Tom
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Search exact name…
You have used remplacer rather than replace in your function. Is that the problem?
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Multiple items from inventory used as one product
I used the Inventory template. I added a table called Kit with 2 joins to the Article table, Kit as Ordered" and 'Articles in a Kit'. This is where you define your Kit.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Multiple items from inventory used as one product
Hi Tom I'll take a look at the Inventory template. Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Multiple items from inventory used as one product
Hi Tom In ERP terms this would be called a Kit. It's like a Bill of Materials but instead of the parts being turned into something different the parts remain as they are but sold together in the Kit.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Search exact name…
If your field is called Name then add a formula field with this formula "*" + replace(Name, " ", "*") + "*" It will turn Ara into *Ara* and Ara Vert into *Ara*Vert* etc.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
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
1
19
20
21
22
23
24
25
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics