-
Ninox HTTP Calls syntax
What is the right syntax? In documentation (https://ninoxdb.de/en/manual/api/http-calls) its mentionned : 1. http(method, url)2. http(method, url, body)3. http(method, url, headers, body) for then 3.…
-
How to create a field that allows multiple choices
I would like to have an address list that classifies what type of contact the person is, 1) Owner 2) Owner's Rep 3) Architect 4) Creative Director 5) Designer and so on --- BUT --- I need to be able…
-
Dynamic Reports
Trying to create a table of check using a WORD document with no success at all so far. The first screenshot is the Word table with fields which I believe is correct.…
-
How to copy PDF file from Image field to new record.
Hi there! Hope someone already had to go through this: I'm copying records from one table to another (and then deleting them). Everything seems to be fine,…
-
Font in print layout
I would like to integrate the Arial Black font into the field where the number 978 is indicated in the print layout. I set the Arial Black font from the desktop app for mac.…
-
Need Help with view table.
@Fred I have the this formula and works excellent, I can search by Name and Dates at the same time. (Two search), but I will like the view table appears without information when I open the search…
-
Switch with multiple for loops and consequents new records
Hello, for each person, I need to list all the academic years that person has been or is being hired, along with the startDate and endDate for each academic year resulting.…
-
Dynamic Multiple Choice Field - How to Programmatically Assign
Hi - the latest Ninox update has lots of interesting new features to play with, great to see it launch. Dynamic lists is something we've all been clamouring for.…
-
Accessing a single line item on an invoice
I'm trying to pull the TOTAL value of a single line item in an invoice that has 3 line items consisting of £195, £56, and £18. After trying everything I can think of,…
-
Related table field reference
ok....I know that by the time I will read the answer I will feel very dumb, but...sometimes you have to learn things the hard way I created a N:1 relationship between TABLE1 and TABLE2 and now in…
-
Testing a due date from the Global Trigger after open
I want to test for a table (jobDockets) for any occurance where the dispatch date (DispatchBy) is due within 2 days of today upon opening the database at the start of each day.…
-
How can I change the font size of a Number field
How can I change the font size of a Number field
-
How do I format this field?
I've tried everything in the display as field, but nothing changes as to what is displayed.
-
Time Interval wrong calculation
Hello. I've set the code to calculate the time interval between a dropoff and a pickup. The formula works but for some reason it adds 1 extra hour to the correct calculation..…
-
Remaining to a date & style
Hi. I have this: let Countdown := 'Data d''inici' - today();styled(text(Countdown), if Countdown = -1 then"red"elseif Countdown < 0 then "Orange" else "white" endend) I want to format the f(x) like…
-
Impossible to put a line in the form !
Hi When I select a line in the layout option it disappears ! I click on the key, it appears, I can modify it…but when I deselect the key, it disappears ! Can someone tell me the secret ?
-
I would like to create a sum formula based on yes/no fields...
Evening All, I work in construction and i am trying to build a quotation form that will allow me to add various sections as our projects vary quite a bit,…
-
Comment Group, VLookup assistance
Hello, I have an invoices database, with a table named Invocies, within invoices, I have a text box called "Comment" I use the comment field to sort-of organize my invoices the way I prefer.…
-
can I set and use global variables ?
for example i go to the option panel of my database (admin mode) and i type : let pn := 110;void and then i would use pn (how to call "pn" back btw ? just use pn ?…
-
Form disappears with Escape key
When I'm in a form e.g. Invoice Form and hit escape key the content disappears. Is this a bug or a feature I'm on Ninox Mac App
-
Sending attachments via API
Hello, I'm using a lot of Dropbox API woth Ninox to manipulate files and folder. I want to send a record attachment to my dropbox. I can use the "upload" dropbox API to create textfile from Ninox but…
-
User interface automation
I use Ninox on iPad and am trying to implement some user interface automation to create a switchboard of buttons for single click user access to different database activities.…
-
Recap DB
Hi, I created a DB that counts more then 30 tables and totally a huge amount of fields. Is it possible to obtain a report not about the records contained in the field but about the formulas, triggers,…
-
How to calc sum of date specific entries in one table from another
Hi, I’m new to Ninox, having come from HanDBase for iOS (which I found had a simpler method of calculation). I’m trying to create a table that summarises entries in another table for a given date.…
-
chiose table from a variable
Good morning everyone! With this script assigned to a button, I would like that the name of the table on which to create a new record to be based on a field of another table where the script is…
Answer questions and share your knowledge