-
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.…
-
locking a field
How can i lock a field after pressing a button.
-
Data Model Tab/Page is Blank? (Beta)
Hi all, I hope everybody is well!! ... :-) Is anybody else having this issue (Ninox Cloud/Beta version), or perhaps I'm just missing something? In Admin,…
-
Search Files by text in filename or for records that have files attached
e.g. I have an attachment called amd.pptx in one of my tables somewhere. I can't: a) search and find which record has the file b) search or display all records that have files attached I'd like to do…
-
Dialog box from Update trigger
I cannot get a dialog box to popup if I put it in the 'Trigger After Update' script. I can get an Alert to popup from there - but not a dialog. I can copy/paste the same dialog into a formula or…
-
Programatically set image field content
Is it possible to set an image field using the attached file with built-in scripting functions? ie, image = file(this, Name + ".png")
-
Bulk email through Ninox
If you are sending an email to more than 1 client through Ninox, I see it addresses each client and clients can see other clients. Is there a way to do this as BC (Blind Copy) Currently using the…
-
create an array with a multiple values
Hi. How can I create an array containing the outgoing values of a loop for?