John Halls

John_Halls

Somerset, England

Joined: Thu Feb 11 10:04:26 UTC 2021

My Posts

Latest Posts

Re: Barcode scan inventory number using iOS app
Hi. As far as I am aware only Code39 and Code128 allow for charcters in the barcode. Code39 needs the code to have asterix placed at the start and end, so 970862262VMENON would have to be…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Barcode scan inventory number using iOS app
What format is the barcode?
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: To sort the groups…
I created a formula field with a group count followed by the name of the group let g := this.Group;let n := cnt(select Table where Group = g);let t := lpad(text(n), 3, "0") + " " + Group;t This gives,…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Same words which should not be repeated…
I'd be interested to know, did it work and remove the multiple instances of the same group?
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Same words which should not be repeated…
trim(Ordre)
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Same words which should not be repeated…
A box appears to the right once you select Assigner ue valeur calculee. Click in this and the script editor appears. You can type trim(Ordre) and then click OK.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Same words which should not be repeated…
Hi Its the one called Assigner ue valeur calculee. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Same words which should not be repeated…
It's John. It's not to do with filtering. See my instructions above, and also look at https://ninox.com/en/manual/tables/update-multiple-values Choose Assign calculated value for the Ordre field.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Same words which should not be repeated…
If so use Update multiple records... and for the Ordre field Assigne calculated value. Use the formula trim(Ordre) Click Next to see a preview of the the result before you Execute Update
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Same words which should not be repeated…
Check for trailing spaces "Passeriforme" vs "Passeriforme " vs "Passeriforme " This would give three groups
- John_Halls
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Search exact name…
This works ="Ara" or like "Ara " or like " Ara" Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Not like "word"
Try not like "jaune" and not like "noir"
- John_Halls
- 4 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
- 4 yrs ago
- Get help
- Reported - view

1 27 28 29 30 31 32 33

Welcome to the Ninox community

John Halls

My Posts

Re: Barcode scan inventory number using iOS app

Re: Barcode scan inventory number using iOS app

Re: To sort the groups…

Re: Same words which should not be repeated…

Re: Same words which should not be repeated…

Re: Same words which should not be repeated…

Re: Same words which should not be repeated…

Re: Same words which should not be repeated…

Re: Same words which should not be repeated…

Re: Same words which should not be repeated…

Re: Multiple items from inventory used as one product

Re: Search exact name…

Re: Search exact name…

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

Overview