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: To copy-paste values from a record to other ones ?
I'm currently working on a client's FileMaker Pro system where the previous developer had scripted copy & paste instructions to transfer values from one field to another.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Button to copy field entries from one field to another (running through entire table)
Thaks Sean. I missed that!
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Button to copy field entries from one field to another (running through entire table)
I know "this" is a reference to the current record but can I ask what the line let key := this does? There's no mention of the variable key anywhere else. Thanks John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Display last 3 records in a table
Hi I've just tested this out of interest and I can confirm that if you follow Alain's instructions it will give you a table exactly as you want. It's an imprssive solution from Alain. Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Sales growth
Sorry, it looks like I am wrong. The values are not aggregated.
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Sales growth
Hi Jan If your sales table has a sales date field 'Date' and a sales value field 'Value', add a formula field 'Formula' using the function Year/Week(Date) or Year/Month(Date).…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
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
John_Halls
3 yrs ago
Get help
Reported - view
Re: Barcode scan inventory number using iOS app
What format is the barcode?
John Halls
John_Halls
3 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
John_Halls
3 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
John_Halls
3 yrs ago
Get help
Reported - view
Re: Same words which should not be repeated…
trim(Ordre)
John Halls
John_Halls
3 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
John_Halls
3 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
John_Halls
3 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
John_Halls
3 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
John_Halls
3 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
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
1
23
24
25
26
27
28
29
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics