-
Joining text strings with carriage return
I have a clients table where each record has several address fields. Eg. address 1, address 2, city, state, post code, country. I want to join these fields into a single multi-line address but…
-
gráficos
HOLA, ALGUIEN ME PUEDE EXPLICAR COMO FUNCIONAN LOS GRAFICOS, SEGUN VEO EN LA VERSION CLOUD ES DIFERENTE (NO VEO LAS VISTAS). NO SE COMO SE SELECIONAN LOS DATOS PARA EL GRAFICO. GRACIAS DE ANTEMANO
-
Many to Many Relatonships
I am tying to create a Many to Many Relationship Table between Priests & Parishes using the 3rd table named "Priests Parishes". There 300 Priests and 150 Parishes.…
-
SELECT function
Hello, which is the best way to identify records if the table as a below relation: Table A link to table B, and table B link to table C. I need to count records in table C based on a filter related…
-
Sum Specific records of certain year based on a date field
Hi All, Is there a way to make ninox recognise a certain year of a date field. i.e I have a date field in one table a count of people in the table I would like to get a total count of people in a…
-
How to turn 5x reference columns in a CSV into a single reference column containing all 5?
I'm trying to import from .CSVs where the fields I intend to link look like this, with added notes to show where I want the links to go. Genres GenreID (PK) GenreName Movies MovieID (PK) MovieName…
-
Format date and time field
Dear Ninox users, I have a question for you: I need a data field that include the seconds for example 15/01/2022 18:00:34. Please help me!. Many thanks Massimiliano
-
Import csv with usernames as field
Hi, I am importing fields from csv. One of these fields contains a property "Asset Manager". The property type is Username. When I import the field is ignored.…
-
Filtering the table view
Often seem to have problems with this. Particularly if the column in question has 'Conditional Formatting'. I am currently trying to filter a table and NOTHING is working.…
-
print view
I should be opening a view in a report, can anyone help me?
-
4 week running average
As a truck driver, I get paid by the mile. I need help figuring out how to look up and calculate the average miles driven in the last 4 weeks (6 weeks, 13 weeks).…
-
Script: Test for 'if this is true and that is true, then..."
I have a working script which does what I wanted, some reference numbers need to be in the format AB-C-D and others ABCD. With and without hyphens depending on two tests. if 'Year Code'.…
-
Button um vorhandenen Datensatz auszuwählen
Hallo liebes Forum, wenn ich über einen Button einen Vorhandenen Datensatz aus einer Verknüpfung auswählen möchte was müsste ich bei beim Anklicken reinschreiben ? Danke für eure Hilfe
-
Problem with print
I have created a layout but when I try to print it , it allows me only to save the pdf. I do not see the possibility to choose the printer Could you help me?
-
Auto-Import a CSV
Is there a way I can have a CSV file on my computer that sends the changes to it hourly to Ninox to update records? If so, how do I achieve this? Can I do so with PowerShell? Thank you,
-
How can i get totals from a job type?
I have 3 job types Wedding Setup Family Portrait Wedding Officiant They are all in the customer info under Job Type. How can i get a total for each job type for month and for year?…
-
Est il possible de récupérer les x caractères de gauche de la valeur d'un champ ?
Bonjour; Est il possible d'utiliser une formule pour ne garder que les X caractères de gauche d'une valeur d'un champ ? J'ai par exemple un champ reprenant un nom de fichier qui commence par un…
-
Dynamic Reports
Trying to create a table of check using a WORD document with no success at all so far. The first screenshot is the Word table with fields which I believe is correct.…
-
Build a Report Advice
Ok, I want to create a Form within my Ninox CRM that will allow a user to select pre-defined reports, click a button, and then than upon click it will create a new record for that corresponding…
-
QR Code management
Hello everyone. I would like to start managing QR Codes in my database. I saw on the forum that creating a QR Code is actually quite simple. “It is enough”, in summary,…
-
All-day 'Appointments'
I need to show events / absences in the calendar that are multi-day. The 'Appointment' field is, I think, the one that permits different start and finish dates.…
-
Creating record from another table
Try to create a record via button from another table (T2), where values of fields (of this T2) automatically been put into respective fields in T1 ... fe.…
-
2FA?
Does Ninox support 2FA — either for the developer or for ordinary non-developer users?
-
Multiple trigger after update
Hello everyone, does someone know if it is possible to write multiple trigger after update in the same field ? I'm sorry but I'm not so expert in coding..…
-
auto populate email field
Hi guys Is there a way to automatically populate an email field with the mailadres from a person from a linked table? In this scenario I don't want to use the Formula-field because this formula field…
Answer questions and share your knowledge