-
Calendar
Dear Sir, Is there a possibility to repeat an entry weekly ? The anniversary only takes repeats on a yearly basis ! I need weekly , every second week , monthly event repeats Just lazy I guess :…
-
How can I copy from a text field to a date field?
The text looks like dates but doesn’t sort properly.
-
How do I go Back to see the Parent form ?
let p := record(SoftClinincPatientFiles,1);openFullscreen(p) I am in a subform This takes me to the correct screen (Parent) but record 1 How can i tell it to got to the Current Patient Id Parent form…
-
Help with creating an automated 'Invoice Status' based on date fields.
I have a 'status' field which is generated by a formula as follows, but not quite working: let nw := today(); let dd := 'Date Due'; let po := 'Paid on'; let rm:= 'Reminder Date';…
-
Location Function
How can I, automatical get the address from a table to input in the location maps funciton?
-
Get history records via API?
Hello, Is it possible to get the history records via API ? Regards, Guilherme
-
Moving DB from mac desktop to ninox cloud acct
Hi there I had bought mac desktop version and then I got a free trial cloud account (My Team). In my desktop app I can see and manage dbs created in the cloud (synchronized),…
-
Mac desktop and cloud
I'm using the Mac version, and it's working well. I would like to share some of the tables so that others can read them, and possibly download files. Do I have to get a Cloud account to do that,…
-
Convert
Is it possible to convert a Text field into a DAte field and with the correct format if possible ie DD/MM/YYYY ? I imported the entire database but erroneously did not set the date field to date!
-
Array formula
let arr := [item(URL2.'1 - EV master file', 0)];for p in URL2.'1 - EV master file' doif p.UID_Key = 'Link 3 ID' thenarr := array(arr, [p])endend;if 'Link 3 ID' > "" thenarr := slice(arr, 1,…
-
Filter to show only one unique record if multiple same records in field
How should I state a filter to show only one instance of each record in the UID_key column. Thanks
-
Search and add a field from another record in same table to a record
let me := this;if LinkUrl1 thenfor i in select '1 - EV master file' where UID_Key = me.LinkUrl1 and Id != me.Id dolet myResult := (create URL);myResult.('1 - EV master file2' := me);myResult.…
-
MJMPM
Hi I'm a complete novice with ninox at the moment, i was getting on fine with it till i triesd to connect to my email addressee emails. When i click on the small evelopes it takes me to another…
-
MJMPM
Hi I'm a complete novice with ninox at the moment, i was getting on fine with it till i triesd to connect to my email addressee emails. When i click on the small evelopes it takes me to another…
-
Finding record in another table and returning a field
Hi, please help. I want to find the value entered in LinkUrl1 in the tabel EV strategy and then return WEV Brand Page from that table to URL1. thanks
-
Sum Qty in selected field for each Value in Arrray
HI , i have a formula field that has an Array of product code numbers i have a table with orders i would like to select the Order table and sum the qty on order for each product in the Array Field…
-
Field to pop in as an alert when pressing a button?
Hello, I have created a button to reject my quote when not approved by my client. Is it possible after pressing the button to have a pop up alert field where I could enter the reson for the rejection…
-
Button to add record and populate choice
Hello, Is it possible to have a button create a record and preselect choises in the form? For example I have a File table, that stores different files/attachement.…
-
Preventing filed duplication that contain alpha and numeric values?
I currently have a simlar fomula to prevent a unique refrence filed being duplicated if is a number, however my client refences are a mixture of letters and numbers (i.…
-
SQL "In" Script
Dear all, hello! I am new to Ninox and really excited about it. Great job guys. I need 2 different things as described below: I have a parent table who adds records in a child table…Customers ->…
-
expire date
Good morning i have table where i have one Field call start date , one field where i need put the duration in months and one field where i need to calculate the expire date ,…
-
Untertabelle Summe
Hallo zusammen, ich würde gerne die MwST aus der Summe von der Untertabelle berechnen, geht das?
-
Doppelter Datensatz vermeiden
Hallo, ich benötige mal eure Hilfe für folgendes Problem. Ich möchte gern vermeiden dass ein Datensatz (Textfeld "Vorname" und Textfeld "Nachname") in einer Tabelle (Kunden) mehrmals hinzugefügt…
-
Best way action to selected records
Hi, I need some help, because i dont find a solution for my basic of basic problem. Ok then i have a simple table Contact. In this table i have many records. Thes basic from basic.…
-
"Readable if" for specific user group
We want admin group to see everything, but we want other users to only see information about themselves. I used the user() function and provide that other users only see information about themselves.…