-
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,…
