Paul Chappell's Profile | Ninox Community

Latest Posts

Re: Button to validate required fields
This is a consequence of the way Ninox is designed. Fields can be marked as "Required" but there is no way of using that information in a trigger, as far as I know.…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Impossible to add a new recording…
Not really without something more to go on. Such as: Which platform are you using? Do you tables have access to create records? Have you tried refreshing the records view?…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Cut & Paste a screenshot.
Well, yes. Sort of. Using a Rich Text field. Do a screen grab using whatever method for your particular platform, and then just copy and paste into the field.…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Reference to items in the same table
@Fred @vincent. cattersel Yes. In any case, no-one wants to scroll through (or choose from) 450 items in a list. It would probably be better to structure your table to allow the items to be…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Reference to items in the same table
@vincent. cattersel Yes. If your table is called Items you just need to say select Items in 'Dynamic value'. Apologies: it should be select and not Select.…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Reference to items in the same table
@vincent. cattersel It sounds like you need to use a 'Multiple choice (dynamic)' field. In the 'Dynamic value' property of this field type Select Items,…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Urgent Problem with resize column on Subtables and Views
Yes. It is also a problem with the iPad version. Columns can be resized but only by quickly tapping between the fields and moving very gently.
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Font question
@zenmom There is a simple way to change fonts and styles using html tags, but this only works on formula fields. Example: let result := "This is a test"; html("<style> .…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Date formats
@zenmom The solution to this sort of problem is to use the month as numbers, but formatted in reverse order: format('date paid [raw]',"YYYY MM DD")
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Script to confirm date-time availability
@bflack Assuming that your "Stays" table is linked to a table containing the property details - I'll call it "Property". In your Stays table you should use a combined 'Date+Time' field for "Arrive"…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Extract year from date field in text format
substr(field, 6)
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Sub-Tables - Add existing record
@John Halls Yes. That was my thought. Composition set to Yes combined with being Hidden should mean that a sub-table HAS to link to a master table. Making the 'Add existing record' button redundant…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Sub-Tables - Add existing record
@Sean Thanks for this! I already use similar hidden formulas for controlling user access to Delete, Add, and Copy buttons etc, so this will be perfect!
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Sub-Tables - Add existing record
Thanks @Fred Yes you are right and Ninox have confirmed as much. I just can’t remember it working like this. Must be old age. The fact remains however that I can’t think of a use-case where a hidden…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Sub-Tables - Add existing record

Has something changed with the new version (3.7.6) with regards to sub-tables? When a table has a sub-table linked to it there are now two buttons on the sub-table to "Add existing record" and…
- Paul_Chappell
- 3 yrs ago
- 6replies
- 542
- Get help
- Answered
- Answered
Re: Google Maps - iframe in Ninox
Or you could just launch a Google Maps webpage from a button. In the UK we use postcodes so I put this code in a button On Click: openURL("https://www.google.co.…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: The number of days in each month of the day period and its total
@Rafael That's right. The formulas are not used in isolation. Clearly, you have to show a resulting variable. let FirstDayOfFirstMonth:=date(year('start date'), month('start date'), 1);…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: The number of days in each month of the day period and its total
@張良仲 Thank you for the example. I'm still not quite sure what you are trying to. If you are entering two dates and need the number of days between them, then you use: let NumberOfDays:…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice "order by Id" gives incorrect order
All systems will order text fields in this way, even Excel. The data is seen as alphabetic and sorted accordingly. To get a true numeric order you need to convert to a number field.
- Paul_Chappell
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: [HELP] Ninox Can't Perform Basic "Sumif" Function
@Borgir! So.. Did that work?
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: [HELP] Ninox Can't Perform Basic "Sumif" Function
I had a similar problem. Try this: do as server sum((select 'Line Items' where SKU = curRec).'Item Cost') end
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Prevent old record editing for users with limited access rights
@Agassi Yes. 'Created on' includes the time. So instead, in your record (or field) "Writable if..." use this: userRole() = "admin" or date('Created on') = today() The record (or field) will only be…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Prevent old record editing for users with limited access rights
@Agassi Yes. Anywhere.
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Get Previous Month
@John Halls Yes. In other programming languages you might have to do the calculations manually. But Ninox is clever enough to know that date(2022,0,1) is 01/12/2021 and date(2022,-1,1) is 01/11/2021,…
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view
Re: Prevent old record editing for users with limited access rights
@John Halls @Agassi Yes. 'Created on' is an inbuilt date function.
- Paul_Chappell
- 3 yrs ago
- Get help
- Reported - view

1 2 3 4

Welcome to the Ninox community

Paul Chappell

Re: Button to validate required fields

Re: Impossible to add a new recording…

Re: Cut & Paste a screenshot.

Re: Reference to items in the same table

Re: Reference to items in the same table

Re: Reference to items in the same table

Re: Urgent Problem with resize column on Subtables and Views

Re: Font question

Re: Date formats

Re: Script to confirm date-time availability

Re: Extract year from date field in text format

Re: Sub-Tables - Add existing record

Re: Sub-Tables - Add existing record

Re: Sub-Tables - Add existing record

Sub-Tables - Add existing record

Re: Google Maps - iframe in Ninox

Re: The number of days in each month of the day period and its total

Re: The number of days in each month of the day period and its total

Re: Dynamic Choice "order by Id" gives incorrect order

Re: [HELP] Ninox Can't Perform Basic "Sumif" Function

Re: [HELP] Ninox Can't Perform Basic "Sumif" Function

Re: Prevent old record editing for users with limited access rights

Re: Prevent old record editing for users with limited access rights

Re: Get Previous Month

Re: Prevent old record editing for users with limited access rights

Overview