Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

756
123
1

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

My Posts

Latest Posts

Re: AGE function
I have double checked the code as written and I am sure I have copied it out correctly but I have been testing it and I am getting some odd behaviour. I wouldn't use this code just yet!
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: AGE function
Hi You need to put your global function in the Global script definitions section, found under the Options tab The script from the video is this (screenshot taken from the video) Here is that code…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: AGE function
Hi If you tell me what ageYM does I am sure I can re-create it for you. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Using formatted name as form header
Hi Michael Create a formula using SpeciesName in the formula. Formula fields have a Style option and you can change the font size to Large or Very large Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Use Update Trigger to Chnage the value in Linked Record
On reflection I would add a Yes / No field to your Main Category (English) table. Call it Disposable and set it to Yes where Product Type (English) s "Cups", "Napkins - Christmas", etc.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Use Update Trigger to Chnage the value in Linked Record
Hi Matt You don't need to set t because Features is a reference from Products, so your code can become let x := text('Main Category (English)'.'Product Type (English)');…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: use yesterday's information in the table
Always post that litte bit too soon. Just realised the RunningTotal isn't correct. This might have to be scripted but still pretty easy to get going.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: use yesterday's information in the table
I created a tabe called DaisyChain and made a table reference to itself, one half called Yesterday and the other Today I included a field called Flag. Every record except the latest has been set.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: use yesterday's information in the table
I know Alain has found a solution for you but I'd like to suggest something. If I were doing this I would have a relationship joining yesterday to today created in the Trigger on create section.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to count using where with child and linked tables data
Replace where code = "C1" with [Code = "C1"] The where and square bracket formats both work with select statements, only the square bracket format works with a relationship field.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Popup related record
Hi Jan. It's a forum, not support. I like to think that, between us we all provide professional, detailed answers as best we can to all who come here from the simplest of queries to some more…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Select from another table
Hi I suspect the reason you are not seeing anything is that nazwa_p and producent are not exactly the same. They have to match in spelling, capitalisation,…
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: Relationship between a table and itself
Having made one relationship Peter - Son - David and noting the that reverse relationship is Father (the Reverse field) the button is creating or updating the second David - Father - Peter Lines 1 -…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Using Ninox seems like pulling teeth!
It's not Ninox, it's the problem, which is quite a complex one. I have just posted a solution in response to your request a few hours ago which I hope restores some faith in Ninox.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Relationship between a table and itself
So this works. The fields were hard to name, so sorry if they don't make immediate sense. I have added a reference to link the pairs in the Relationship table.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Relationship between a table and itself
Hi all. First of all it's not quite as simple as it may seem. It is a many-to many join with Person - Relationship - Person so you may have some data that looks like this Peter - Father/Son - David…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Sharing Databases
Hi Romain Yes you can. As above, they would need to be a member of your team. Use the 'Readable if' option of the table together with the user() function to only display records belonging to that…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: I have been using Ninox for over a year now and create identical fields over multiple records as I am keeping information on clients (broken up between male and female) but now when I try to edit anything, it gives an error message saying 'ambiguous field names'. I have seen that fields that can't have the same names but why is it, that I have been able to do it for the last year but now I can't?
Hi Rhysm If you have the same field names in dierent tables it might be a sign that your database is not normalised correctly. Can you send over a screenshot of your data model. Thanks John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Create / Update Record
Hi Dave I would create a relationship between Orders and Expenses and update your code to this:- let a := first(Expenses);if Postage != 0 and Postage != null then let d := Date; let desc :…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Does a button only work once ?
I wrote this code for you, and my understanding was that you had duplicates that you want to cleanse from your table. The button would flag the duplicates in preparation for that.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Code to Generate PO Numbers
Here you go... let a := this;let b := format(today(), "MMDDYYYY");let c := "ABCDEFGHIJKLMNOPQRSTUVWXYZ";let d := "";let e := substr(last(((select Orders where substring(Ref, 0, 8) = b) order by Ref).…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: I can't get a Dynamic Choice to select from a table. It works in other circumstances.
Hi Mark This is what the manual says:- record(tableName, recordId)record(tableName, recordId).fieldNameUse the record function to return the nth record id of a table as a handle.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Automatic record creation
Sorry, hit 'Post' before I meant to. The code will look like this if Table1.Formula > 0 and cnt(Table1.Table2) = 0 then let a := Table1; let b := (create Table2); b.(Table1 := a)end Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Automatic record creation
Hi Giovanni You can place the trigger in Table 3 as this is the table being updated. Use the Trigger on update and place this code in it
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: No duplicate absent…
Fred is right. This is working but, depending on why you are doing this, it won't get you any further forward in finding one original and deleting or flagging the duplicates.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 22 23 24 25 26 31

Back to top

Ninox-Documentation

Overview

View all topics