John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Multiple items from inventory used as one product
I'll put something together over the weekend Tom
- John_Halls
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Search exact name…
This works ="Ara" or like "Ara " or like " Ara" Regards John
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Not like "word"
Try not like "jaune" and not like "noir"
- John_Halls
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Error in a script to find duplicates
Can you post a screenshot of the code
- John_Halls
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Recors counting
That should have read 'automatically update as you add'
- John_Halls
- 5 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
- 5 yrs ago
- Get help
- Reported - view

1 29 30 31 32 33 34 35

Welcome to the Ninox community

John Halls

Re: Multiple items from inventory used as one product

Re: Search exact name…

Re: Multiple items from inventory used as one product

Re: Multiple items from inventory used as one product

Re: Multiple items from inventory used as one product

Re: Search exact name…

Re: Search exact name…

Re: Search exact name…

Re: Search exact name…

Re: Search exact name…

Re: Not like "word"

Re: Error in a script to find duplicates

Re: Error in a script to find duplicates

Re: Error in a script to find duplicates

Re: Error in a script to find duplicates

Re: Error in a script to find duplicates

Re: Error in a script to find duplicates

Re: Error in a script to find duplicates

Re: Copy Data from one for into another then open that new record

Re: Copy Data from one for into another then open that new record

Re: Formatting printing of forms

Re: Is it possible to have a filter expression for character count?

Re: Recors counting

Re: Recors counting

Overview