Andrew
-
XML Data File
Hello, Is there a clever way to import data from an XML file into Ninox? Andrew
-
If Statement between dates
I am trying to figure out a formula to give a value using the If statement but am struggling to make it work. I need something like this: if 'datefield' >= '01 Aug 2016' and <= '31 Jul 2017' then…
-
Multipage PDF reports
It would be great to be able to easily create multipage PDF reports. We are trying to use NX to manage contracts that run into about 5 pages and it appears to be a difficult process to do this right…
-
Calculating an age at a certain time
I am trying to calculate the ages of students when they start a programme. I had this in a ms sql database as (floor(datediff(day,[DATEOFBIRTH],[LEARNSTARTDATE])/(365.…
-
Filter view
I have a view that is looking up data using let u := ULN;select 'Indicative Earnings' where 'Unique learner number' = u This produces: What I want is for the select field ILR Year to filter records…
-
Import files from Amazon S3
I have a bunch of files that are currently stored on Amazon S3. I have tried to import some into specific records using importFile(this, "The S3 URL") The files are set to public but I can't import…
-
Database look up
Is it possible to look up a table in a different database? Thanks
-
Display chart
Hello, I have a list of dates but want to show volumes of activity in a month. I have managed to create the format of the date by using format('Start Date', "MMM,…
-
Re: How do I input a csv table list into a multiple choice values table? I have a 100 choices and I don't want to type them all out.
I have a nationality field and have all nationality options in a CSV file - Birger, I would also like to know how I insert these into a choice field without having to add them in manually one by one.… -
Table Look Up
If I have a table called 'members': Member Number First Name Last Name 562323 Fred Smith 678944 Jane Jones and I want to upload a CSV file into another table called 'books' Member Number Book Title…