-
Dynamic combobox/dropdown list
Sorry in advance if this has been solved before. I'm trying to create a table with a couple dynamic comboboxes. If option 1 is selected for combobox 1, then only options 1 to 6 will be available in…
-
Need a Constrain
Sorry to bother Fred, I need the constrain for WBS level 5, and. I sent you a mochet. Thanks
- Answered
-
Creating a new record in a linked table using code
I have 3 tables linked to create a many to many relationship. The relationships look like this: [Locations] <--- [Location Tracking] ---> [Tracking] Multiple tracking records and be related to every…
-
Extract certain variable numbers from attached file title
Hello everybody, I'm working on an archive of graphics files. I've imported preview graphics as images and extracted the title with this formula: extractx(text(Preview), "(.+)\/(.…
-
Copy text field to reference field
Hi Brain Trust, Is this possible? I would like to trigger after update a text field (copy a text field) to a reference field. They are both in the same table.…
- Answered
-
How commercialize a template ?
Since several days, I'm working on a ninox template, I would like to "market" it through a license system. To describe how it works: everyone can pay to use my template for a specific period (1 year…
-
Converting min/mile
Is there a formula in Ninox that can convert a time of say "32:14" for 2 miles into Min:Sec per mile? In other words, I don't want 15.50 min/mile, rather I which to generate a text of "15:…
-
Links in forum threads
Just a heads up... If you post a link in a forum thread it will be appended to whichever subgroup you are in. If I posted a link here it would be appended to https://ninox.…
-
Timestamp UTC/GMT - formatted in english
I“m working on a log tool and have an issue. Is there a simple way to get a UTC timestamp to a field? Normally when I use ”Date Time“ I get my local date and time.…
-
Copying tables
Ninox is great when you want to copy an entire database, but, as far as i know, not so great when you want to copy and individual table to another db. I have 3 different databases:…
-
Getting the Year & Month between two dates
I created a convoluted formula to calculate the age of a student at the start of a course. The basic idea is 'Course Start Date' - 'Student Birthdate' I was hoping someone could give me some pointers…
-
Is it possible to make a view with a top 10 only?
Let say I have client and purchase. If I wish to make a view with the 10 biggest purchase for exemple, how should I do it? To sort the result, should I use the built in filter or do it in formula?…
-
Custom made Icons
Hi, is there any workaround to add custom made icons? thank you
-
Email field
Good evening, is it possible to add an email address as Cc or CCn in the email field? many thanks
-
Display associated content with conditional constraints.
In table HOME, there is a record with "nb" as 1. I want it to display the associated content with table copy, but without showing duplicate names, similar to what is shown in "show" (but excluding…
- Answered
-
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
-
Workspace ! Not being recovered where images are held & deleted.
Storage of image files and deleting them do not automatically give you your workspace back. I have copied this from another post that I answered as it seems to me that other users are now having…
-
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