-
Ninox on windows 10
Is there a timescale for when the windows 10 version of Ninox will be available or is it just vapourware?
-
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
-
How to select a row from a composition table to display in a superform
I am new to Ninox and am struggling a little with programmatically searching records - the equivalent of SQL-world Select statements) . I have many years of relational database experience in…
- Answered
-
Operators for searching one/several texts in the field filter (Boolean)
From time to time you need to search for several texts in a table column at the same time or you want to exclude certain texts from the search. To do this,…
-
The CRM Ninox Hero Webinar with Employees, Deals, and Companies
I saw the Ninox demo from 2011 which went through setting up a basic Ninox application with. In that demo, however, in the "Deals" area, only one linked employee is ever shown.…
-
Save record as PDF
I have created a print layout for my invoice records. Is there a way to reference this view in code so I can create a pdf via a button on the form view of the record instead of going through all the…
-
Client vs Server script differences
Hello all I am building a system for someone and have run into a quirk. As an example, if I have a table called Parent and a child called Child, and both have a number field, Number.…
-
Default Value problem
I would like to ask you if you could undestand the reason why I can't set a default value to my numeric fields. Thanks!
-
Is it possible to trigger code on a timer?
For many use-cases it would be useful to be able to trigger code based on a timed event (i.e. 12pm every day) - or triggered by a date field (i.e. date/time = now). Is this in the roadmap?
-
Removing duplicate fields (emails as example) solution
for i in select Table_Name.Email_field do while cnt(select Table_Name where Email_field = text(i))!=1 do delete last(select Table_Name where Email_field = text(i)) end end Enjoy!
-
Required fields
May I suggest the following: If a field is set to be "Required", the form should not be close-able until a value is set/chosen - just like on web-site forms:…
-
extractx() “g” flag workaround
Here is a basic UDF for extracting all of the values that match a regex pattern... function extractxg(src : text,regex : text) do let extValue := “”; let idx := 0; let idxLen := 0; while testx(src,…
-
Creating an address block from different fields
I have a shipping table with different fields for address components (line 1-4, city, state, post code) I can create a block showing the address without the if formulas,…
-
How to update a field with a lookup value from another table?
In the image above, I have selected an employee from the Employee table via pop-up. Now, however, I want to populate the "emp_fk" field in the Tasks table with the Employee's "emp_pk" field from the…
- Answered
-
Aggiornamento del calendario
Bisogna aggiornare le opzioni del calendario, non è possibile per noi abbonati avere un calendario così debole. Forza Ninox !!!!!!!
-
Button to open calendar
Quando creo un appuntamento tramite un modulo ho bisogno di visualizzare il calendario per cercare una fascia oraria disponibile, come posso aprire il calendario e magari anche ridimensionare la…
-
Delete record if fieldA := fieldB
Hi, is there a way to completely delete the current record if a formula field results in a specific value or equals another given field?
-
How to create a 1:M display?
In the display above, I've attempted to show the tasks for each employee (M:1). Although the tasks for this employee shown at the bottom are correct, the possibly many tasks display isn't a "grid"…
-
Are there Trigger limitations?
I have a DCF (DMCF?) where a "Trigger after update" has the code: 'V.Välj Region' := ""; 'V.Välj Distrikt' := ""; 'V.Land' := text('V.Välj Land') it does't work BUT if I have the code: 'V.…
- Answered
-
CSV Import not working on Mac App
I used to use the cloud version of Ninox to all my databases and used to import data via a CSV file. Recently i moved from the cloud version to the Mac App.…
-
Jump to tab from a View
Hi, is there a way to clicking on the result of a view field (which shows the results of records from another table) and jump to that record in a specific tab? (But only from this view)
-
Date of value specific changing
Hello ! I'm looking for how i can get the date of when a value is becoming negative. I'd tried this code : "if 'Value' <= 0 then today() end" but the function today() returns the date of the present…
- Answered
-
SMS/text function?
Is is possible to have a field function that initiates an SMS/text message? It would be separate from the phone number field/button. Similar to what happens now with the phone or mail button,…
- Answered
-
Table Reference Confusion
I created a table reference between employees and invoices. I get the error in the data modeler. But when I add the field to the employee first name (from employee table) to the invoices table,…
-
Searching not working as expected (new to Ninox)
I have a column with a Status. It has values like Complete, Partially Complete, etc. I just want to show the values where it's "Complete", but I can't figure out how to enter that in the search…