-
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,…
-
Trigger after update: refresh table view
Hello. How can I force a table view refresh after updating a record? I have a button that closes the record but I would like to also tell it to refresh the parent table view so I can see the changes…
-
Make/Integromat doubt
I need to automate a process with Make and I have a problem. I have created a Yes/No field and from Make I´m able to modify it. In this field I have written a code in Trigger after the change like…
-
Issue with creating related record from script
I have a Combox that a user can apply "Tasks" to the Client they are working with and normally that occurs from a Triggered Update within a form in the Clients Table.…
-
Conditional Formatting at a stretch using a Filter
Sometimes I miss the filter funnel in the header which throws me when I know there are more records than I see. Especially if the column being filtered is off to the right out of sight so to speak.…
-
logging user access?
Is there a way with Ninox to log when users access the database? I'm interested in knowing who logs in and when. Ideally would also be nice to know when they close the database (i.e.…
-
Duplicate record has stopped working
Hi, I created this code to duplicate a current record, remove information from specific fields and then open that new record. I have been using it successfully for the last 3 years but it has…
-
send an email automatically when a date is reached
Good morning, I would like to be able to run a script that automatically sends an email on a date to a contact and my email as a copy. I have already written the script (which works) but in a formula…
-
Using dynamic reports
I am going to have a bash at setting up a dynamic report using Word. If I create a 2 or more page template for Ninox as a dynamic report does the pagination follow through?…
-
Gruppierungen in einer Tabelle berechnen
Hallo zusammen, ich habe in der Tabelle Rechnungen eine Ansicht erstellt die mit "yearmonth"(Datum) die Monatsumsätze (Nettobeträge) gruppiert. d.h. 2022/7 ; 08/2022 usw. angezeigt.…
-
Need help with very simple for loop
Hey Everybody, Im a truck driver and a very novice programmer to Ninox. Im trying to setup a database to track my loads and I need help with a very simple code I can't remember from high school to…
-
Print report with Multiple choice....how!
This screen shot is pretty much how I would like my report to look: There are three multiple choice fields. When I print this, I get a concat of the choice fields but what I am hoping to achieve is a…
-
Database History
Does anybody know if it is possible to add additional information to the database history? At the moment it is only the table name and record id which is referenced.…
-
How to merge columns together while merging unique cells & offsetting same cells
Hello Ninox community, I'm new to Ninox, a crm that I honestly never heard of before until half a month ago. I've primarily worked on salesforceDC and homebrew crms, so any help is appreciated.…
-
Copying a record using button or Ninox icon
Interesting discovery and I wonder if a solution could be found. If one uses the Ninox icon to copy a record any attachment (maybe apply to comments too) is NOT copied across the the duplicate record.…
-
Balance
Dear all, I'm new in using ninox and i'm trying to set up a database to trace my income and expenses. I'd be grateful if someone could help me for a formula that can give me the balance every time I…
-
Simple Forumla Calc Issue
Hello, I've got a table that shows a list of times spent on a project. Inside each row, I have a time, rate and total field, where a calculations multiplies the rate and time to give a Labour Cost,…
-
I’m not able to login to ninox
Is the only page I'm not able to access.
-
Calendar not updating clients (macOS, iOS etc)
Today my Appointment field events are appearing in the Calendar view (macOS desktop version). Usually they sync also with my calendar client apps on macOS and iOS, but not today.…
-
Send email and include only fields with value
Hello. I do want to send service reports to customers. I have a code which works fine (see below) but I would like to exclude fields from the text in the body of the email,…
-
Import Users into Microsoft Active Directory from Ninox
Hello, I have a table in Ninox used to manager users. What is the best way to automatically import (create, modify) users in AD based on the changes in Ninox?…
-
Formula with a value of the last record
First of all excuse me for my poor english. Let's se if I make any sense. I have a field of total in a record of a day and want that same field start as a balance on the next day i tried to use this…
-
Posting data to api service - Bearer vs Basic (authorization/authentication)
I am trying to post data to a service. It works perfectly with Postman, however, I am still trying to figure out the proper syntax to do the same within a Ninox button script.…
-
Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
I have been trying all sorts of syntax along with using +, and, or to no avail. Here is my formula. let xStart := 'Start Date'; let xEnd := 'End Date'; count((select Chronos)['Date + Time' >= xStart…
Answer questions and share your knowledge