-
How can I add two arrays?
Any idea how you can add arrays in NINOX let a := 1;let b := 2;let c := 3;let d := 4;let ar1 := [a, b, c];let ar2 := [d];let ar3 := [ar1 + ar2];ar3 This will give the result 1234 instead of 1,2,3,…
-
display numbers in ascending order that are in a text field ?
Hi, Is there a way to display numbers in ascending order that are in a text field ? Otherwise how can I copy quickly numbers that are in text fields into number fields ? Thanks
-
It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Dear Ninox Ninja’s, It seems to be impossible to include a “View”-field in the print lay-out? Is that true? If so, any way to circumvent this issue? Here are some details:…
-
Calendar
Dear Sir, Is there a possibility to repeat an entry weekly ? The anniversary only takes repeats on a yearly basis ! I need weekly , every second week , monthly event repeats Just lazy I guess :…
-
Some User Defined Array Functions
aAppend() - Can fill an empty array and adds items to the end of the array.aInsert() - Inserts a new item anywhere in the array except the end.aMerge() - Merges two separate arrays.…
-
Zapier
Hi, i don't find yours app "Ninox"..
-
Adapt fórmula to new Structure.
let check := dialog(" Warning ", " ¿Confirm the Update Transmittal ? ", ["Yes", "No"]); if check = "Yes" then for loop2 in (select 'wbs by Documents')['Name Document'] do let F3 := if loop2.…
- Answered
-
Dynamic Choice triggers twice
When trying to use a 'trigger on update' for a Dynamic Choice field, that actually changes the chosen value, the trigger runs twice. I was under the impression that sensibly a trigger is NOT…
- Answered
-
How can i get totals from a job type?
I have 3 job types Wedding Setup Family Portrait Wedding Officiant They are all in the customer info under Job Type. How can i get a total for each job type for month and for year?…
-
Delete Files added to paper clip
I have an archive that I want to BULK delete various images attached to records. I want to keep the records but no longer need the images that are attached to them.…
-
Need Help to create a History Control Table
I need a Control Table, where every time the FechaR3, FechaR4 and FechaR5 are met in the Documents Table, they are copied to the Control Table with the Document Name, the Code and all 3 Dates.…
- Answered
-
Code the top search - Help
Been working on my DB and thanks to everyone who has been helping me. I think i am down to the last part that needs to be done and i can start using it.…
-
Date fields and timezones issue (Unix vs UTC conflict)
Dear Ninox members, I would like to share my experience with other users as well as ask for improvement features from Ninox support in upcoming updates regarding Date fields that are affected by…
-
while loop stops before reaching end
Hi everyone, I created a button in one table which is to export some values to another table creating new records there. I am using a while loop to create the records.…
-
Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox
I’m trying to replicate a personal-use database that I originally developed in Access 97, and the transferred to FileMaker Pro. I’ve been able to import the data successfully,…
-
Same words which should not be repeated…
Hi In a database I have words written in exactly the same way that are repeated when I make a grouped classification. What is the reason for this? How can I fix it? EG :…
-
Create and Modify Tables
Hi I try to import data for a reference table I use in a database. It consists of 42614 records. It imports without an error message but I end up with no records in Ninox.…
-
Button to Create a New Linked Record?
Hello, I have a link from "Notes" table within my default record. So if anyone adds a note, it creates a new record linked to that one. Within my default record where the "Notes" table is linked to,…
-
Edit PDF
After editing a PDF contained in an image-field using the new editor, if you click on the image-field that contains the PDF, Ninox displays the PDF only in the PDF editor.…
-
Real time clock within a form view
Hello Again All, Is it possible to have clock (face or digital) that keeps the current local time within a form view? Thanks, Sam
- Answered
-
Conditional formula to calculate 'taxable' and 'non taxable' items...
Hello, I'm trying to figure out how to include two fields that calculate the sum of taxable and non-taxable items. If you look at the attached image, you'll see that there's a field for the base…
-
Choice field repeat the value of the previous day
There is a Choice field where there are several options. When creating a new record, i need the value of this Choice field to transfer to the next day. Please advise the formula
- Answered
-
Dynamic Reports - my first attempt
Hi there, Here I was thinking it would be straight forward. I have a docx template and in Word I added {d.'PROJECT TITLE'} as a data field (it's spelt correctly, all UPPER).…
- Answered
-
Re-Creating invoices from the Line table
Hi All, I would appreciate some suggestions on how I could re-create invoices from a table of lines. Preferably creating one invoice at a time from the Line table.…
- Answered
-
coding for create record
Hi, When I click the +Create Record in a referenced table, I get a new record in which the client code (a unique code) is filled in as is the link which the parent (client) table.…
Answer questions and share your knowledge