-
How to enforce unique values in text field?
Is it possible to define a text field to contain unique values only (no duplicates)?
-
Have a Page number on the Print document
Hello :), I'm working on the template for my invoices. Is there a way/ formula do add on the Print document the Page number? I'd like to have on my document:…
-
create options in choice field from variable/loop
It's easy to fill a dynamic Choice field with options from a table/query but how to dynamically create options through something like var options:=[] for i from 1 to 3 do options:=options + i end;…
- Answered
-
Parse Dynamic Multiple Choice into JSON object
I have a DMC field that takes these values (dynamic value): let all_entities := (select elements); let my_event := this; let my_elements := ((select elements where 'parent entry'.…
- Answered
-
Double Search
I have a double search formula ( Name & Format) let me := this; let myArray := (select Albums); if Search_1 then myArray := myArray[Name = me.Search_1] end; if Search_2 then myArray :…
- Answered
-
Getting pdf file from the API response
Hello API experts! I would appreciate your help saving/opening a PDF file, which is the response to an API call. This is the code of the API endpoint call inside a button: let url := "https://testeps.…
- Answered
-
BUG or what?
Hi to all! i am experimenting a simple dashboard formatting fields in a CSS way: the problem is when I go out form this and open a new table: you can see the consequences if I refresh the page:…
- Answered
-
Sum of fields for a period of time
I have a table "credit_Fill" and the second table "Tables". In the Credit table there is a credit field, in which credits are recorded that are related to a particular table.…
- Answered
-
Button to make record
Еhere is a table where all clients are written, and in this table there are several more sub tables. We created a button separately from all tables through it we make entries in all tables.…
- Answered
-
Normalising existing data
I've imported a spreadsheet to a table and now want to normalise it. In SQL I would have done a 'select distinct' on a given field to generate the list of values,…
-
Auto-increment?
Is there currently an auto-increment field of some type? If not, is there a way in code? (I found some old posts, so I don't know how relevant they are anymore,…
-
Formula Problem
let myFrom := 'From Date'; let myTo := 'To Date'; select Documentos where FechaR1 <= myFrom or FechaR1 >= myTo and 'Horas Ganadas Real' = 0 I try to use these Formula but not working I need the…
- Answered
-
Location of data file?
Where is the database data file located locally (I'm quite sure it is stored locally)? Also, how can I tell if it is located locally or if its stored in iCloud
-
Parent - Child Record Update Example. Code Help to Complete Needed.
I hope this will be enlightening for others, in addition, to help to me. Thank you in advance. I appreciate the help I’ve received. Nonetheless, I am working in circles.…
-
Replace all the end of words "XX" by end "Y" ?
Hi Could someone tell me how could I replace all the end of words "ae" by end "é" ? Ex Ciconidae > ciconidé Aramidae> Aramidé Columbidae > Columbidé Falconidae> Falconidé Thanks
-
Is there a way to get internal information (like IP address / hardware (mac) address/ etc??
Let assume I have three iPads accessing an application via the Ninox Cloud.. A user may use any one of the iPads to log onto the application.. Is there a way to determine which iPad the user was…
-
Delete Multiple Records?
Is there a way to delete multiple records?
-
To change the style of the text (color, bold, italic..)
Hi I know how to change of the size of police of the text of the fields but can someone tell me how to change the style (color, bold, italic..) Thank you.
-
Button functions
Hi, is it possible to add a formula at a button to close all the opened table?
-
Attach file
Hi all, is there a way to print and save the pdf generated in the record sheet as an attachment? Thanks
-
Display field only, if: either of two other fields has no data?
What is the formula needed to make this work? The field names I want to check for data are titled Email 1 and Phone 1. I can make the field hidden with either 'Email 1' = null or 'Phone 1' = null,…
-
Multiple choice picks in order?
Hi all. Anyone knows how to extract a list of items from a MC list in the exact order in which those items are selected? I.E. Let's say I have a mc field where 1. apple 2. pear 3.…
-
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.…
Answer questions and share your knowledge