Skip to main content

Ninox-Documentation

Paul Chappell

Paul_Chappell

87
19
0

Joined: Thu Apr 14 07:54:39 UTC 2022

My Posts

Latest Posts

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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: Extract year from date field in text format
substr(field, 6)
- Paul_Chappell
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- 6replies
- 485
- 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: [HELP] Ninox Can't Perform Basic "Sumif" Function
@Borgir! So.. Did that work?
- Paul_Chappell
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: Prevent old record editing for users with limited access rights
@Agassi Yes. Anywhere.
- Paul_Chappell
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: Get Previous Month
Why not just use: date(year(DateField), month(DateField) -1, day(DateField))
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Active or Deactivate specific Budget record
@Rafael Sorry. You indicated you wanted to set the budget to zero. In Budget field, "Display field only, if..." Just say: Active Or Active=1 or Active=0 however you want it to work.
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Active or Deactivate specific Budget record
@Rafael If you're trying to set the Budget to 0 if Active is ticked: if Active then Budget:=0 end And put this in the Active field "Trigger after update"
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Active or Deactivate specific Budget record
You need to look at the field options: "Display field only, if..." or "Writable if..." to only active a field under certain conditions.
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view

1 2 3 4

Back to top

Ninox-Documentation

Overview

View all topics