-
end expected:
I seem to get the end expected error in the below code, but cannot see why.
-
Extract text from linked table
How do I extract and splice the record WEVBrandUID_0273 in the field WEV_Brand_UID in the table 'EVNews' from linked table 'EV Strategy' ? Thanks
-
http Issue sending two json-objects
Hi all The endpoint I call (method: PATCH) expects json-objects with a line break. {"code": "test2", "parent": null}{"code": "test_adriano", "parent":null, "labels":{"en_US":…
-
Set color of text in a formula
"1 -" + item('Brand of Competitors', 0) + " " + item('Model of Competitor', 0) + ", 2 -" + item('Brand of Competitors', 1) + " " + item('Model of Competitor', 1) Hi,…
-
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…
-
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 ,…
-
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…
Answer questions and share your knowledge