-
HTML text format doesn't work in view print preview
I'm using the html() function in formulas to make selected text bold (SECURITY DEPOSIT), leaving text before and after at the default setting: ... Premises.…
- Answered
-
Content Refresh on Dynamic Multiple Select
I've run into a perplexing issue... I have a few different dynamic multi select fields in a table pulling in options from other tables. Content in the name, color,…
-
Dynamic choice fields
Dynamic choice fields With the new Dynamic single and multiple-choice fields, you can create fully dynamic lists with the flexibility to decide the list items, update parameters, display values,…
-
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