-
I am trying to "Mass Update" multiple records. The Manual says it can be done but all of the help text and pictures must be for a different version. Nothing the manual suggest is possible with the 2021 MAC version I downloaded. Any thoughts on this??
I am trying to "Mass Update" multiple records. The Manual says it can be done but all of the help text and pictures must be for a different version. Nothing the manual suggest is possible with the…
-
Trying to e-mail with record in PDF attached
Hi all! Is it me or is mailing with attachments (record in PDF format) still not functioning properly? I have read many threads on this issue and as long as I am working with Ninox I still haven't…
-
Duplicate and Link New Data Entry from One Table to Another
I know this might be a dumb question but I am really new to Ninox so I help someone would be patient enough to read this. I have 2 tables, Product Masterfile and New Products.…
-
Conditional Calculation
I have two questions: 1) I have three fields, "Opening Balance", "Amount" and "Closing Balance". I would like to have a formula in the "Closing Balance" field calculated based on another field…
-
Farbstile zuordnen (Ninox Cloud)
Wenn ich einem Feld vom Typ "Berechnung" diese Funktion zuweise, funktioniert sie: if Relevant = "Relevant" and 'Feld1' = null then styled("Dringend", "Red", "White")else styled("", "White",…
-
Before and After values available in onUpdate events?
Is there something like this.value.before and this.value.after in the onChange events? For example, if building a ticketing system where the status changes from open to pending vs closed to pending,…
-
Free text
Anyone figured a way to make this line up with a regular field? Fields align vertically at their top. So a data field with label positioned above does not line up with any 'Free text' placed on the…
-
Sverweis wie in Excel
Hallo zusammen, ich habe eine Datenbank mit Artikeln. Ich habe da ein Artikel produziert wurde, einzelne Preismaterialien eingefügt. Diese Preismaterialien haben jeweils einen Wert,…
-
Having a problem with dates
Currently having a problem with the date format on the cloud version. I have tried this on multiple computers / on my phone and it works perfectly fine.…
-
Change colour of a formula box if it’s a year later
I have a Last Updated date box and a formula box called Last updated status, I basically want to make it so after a year from the date in the last updated box the formula for the status turns red. TIA
-
How to apply a HTML tag to the entire post and type it only once?
I read How do I use a small font size in questions and answers? and Allow the <small> tag, but I don't want to write <sup> </sup> for each paragraph. For example,…
-
languages supported by Ninox - Suggestion
Coudn't you make portuguese one of the Ninox supported Languages? As you probably know portuguese is the 6th most spoken language. More than French, Italian, Japanese, Russian,…
-
Variables: let vs var
Hi! I'm new in Ninox and I am wondering about the differnce between assigning a variable using "let" statement vs using "var" statement. So far, they've both worked fine in my coding,…
-
Automatic table cleaning after one year
in my database there is a table that collects information about discounts. But they are valid only for a year. How to make sure that all information in the table is deleted after a some time,…
- Answered
-
How do I copy line breaks from a multi line textbox or a rich text field into an email?
Hi all, I need to be able to sent mass mailings to all relations/clients. For this purpose I have created a form with a text field "subject" and a multi line text field "body".…
-
deleted database
How to recover deleted database?
-
Where are my formulas ?
Hi I can't no more see my formulas, only my columns ! How can I retrieve it ? Thanks
-
Console window suggestions
Console is an outstanding tool Ninox provides users to test code before inserting it anywhere in the DB. Nevertheless there are a few drawbacks that make it less useful that it could be. 1.…
-
Trigger on Update not triggering
I want to automatically create some child records in 2 child tables. In the parent table, Trigger on Create successfully creates the required child records in one child table (actually it duplicates…
-
hide and seek
Well, not seek really. I have always thought the way that Ninox hides the parent, when accessing the child through the parent is really neat. So e.g., click on a child line to open that child in the…
-
Image link
I have an image field and would like to create another automatic formula field with the image field link.Anyone able to do it?
-
Modifier date et heure lors d’un changement
Bonjour, existe t'il une routine pour changer la date et l'Heure d'une fiche lorsque on change un ou plusieurs champs de cette fiche. merci
-
Automatic updated field with date for each time I update something
Hi All, I'm totally green with ninox, but I really feel I have tried everything I have read on the forum on how to make field that automatically updates with the date of today each time I for…
-
Problem with unique() function
Hi all, I'm having trouble making the unique() function work. I'm simply writing unique('Project Codes'.Currency) in my formula field. If the values selected are all the same (e.g.…
-
Initials
How can I get every first letter in each word in a field, for example, initial a name? Let say the name, John F Kennedy, I want it JFK. Thanks.