-
Format date & hour
Hello. is it possible to add the day of the week to Date and time? Mercredi 17 juin 2020. 10:08 thanks
-
Incremental numbering continuing from a set number
I need to start incrementing unique numbers that carry on from a set of numbers I have already been using. So for example the last number I will use on my old system will be 02399,…
-
Image Attachement ImportFile
I import a file from an URL and save it as an attachment of a data record : importfile(this, "myPathToFileAndFileName") Work like a charm. My step 2 is to show the file in a image field.…
-
Is there a file attached? Display in a table.
Hi, Is there a way of displaying in a table whether or not there is a file attached to particular records in a yes/no format. I suspect there is (but don't know how to do it) because in the form view…
-
It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Dear Ninox Ninja’s, It seems to be impossible to include a “View”-field in the print lay-out? Is that true? If so, any way to circumvent this issue? Here are some details:…
-
Formula column in List view question
Hello! I got tables Appointments, Treatments, Products. Each Appointment can have one or more Treatment. In each treatment i can use one or more product.…
-
sum formula
I have two choices fields which are filled with numbers, i would like in a formula fields to sum the two fields according to the number i choose, which formula should i use ? I tried : sum('choice' ,…
-
Update the content of a referenced field using the Update Multiple Records... command?
I want to update the content of a referenced field in my table. I select a group of records, invoke the Update Multiple Records... command, but the referenced field is not available to be updated.…
-
Colour - choice fields
Hi. Does anybody know if it's possible to change the colour in a choice (switch) field?
-
Is it possible to use a web form (like a Google Form) so that responses automatically populate a Ninox table?
I want to set up a membership database where members enroll themselves. I would like to use a webform, probably a Google Form, to allow members to enter their information and when they click 'submit',…
-
Assign multiple interested customers to one item?
I have an item table and a customer table. I want to create a link that shows customers interested in a individual item. How do I do this? I seem to be able to only assign one customer using a linked…
-
is there a solution how to code the analog of the excel EDATE function in ninox?
let curr_date:=date(2019,1,31) if I use the following formula for the next_date which is a month later: next_date = date (year(curr_date), month(curr_date)+1,…
-
NINOX - Data Security in Cloud
I cannot find anything about NINOX security, only privacy. I can not find where a place where NINOX describe their physical or digital security measures.…
-
Problem with my code (end expected)
My code bellow don't work and I don't know why. The error is "Fin attendue: if à la ligne 16, colonne 2" In English = "End expected: if at the row 16, column 2" Thank in advance for your answers.…
-
Editing the content of text files
Hello, I have the following issue. Is there a way to import a text file and transfer its content into a multiline field that I could later parse? Then I'd like to know if the opposite is also…
-
Problems sending an email
I don't know what I'm doing wrong but it doesn't work. sendEmail({from: text(userEmail(user())),to: "antonio@farmavazquez.com",subject: "URGENTE",text:…
-
guest
hello everyone, I wanted to ask if there was the possibility of having a guest accout to let my customers access the database
-
How to add a cumlative or running total.
I am using a database application to track hours a machine runs. I have start and end times and a total for that individual record but how can I get progressive totals on following records?
-
Table Linking Not Working
Hi everyone, I've noticed today that the table linking function is not working in the "next" version of Ninox, the system lets you create the tables but when it comes to linking and using the lookup…
-
Vorrei condividere alcune tabelle tra diversi teams come si può fare?
Vorrei condividere alcune tabelle tra diversi teams come si può fare?
-
Selecting a single record in a table view
I am trying to select a single record from a view from a separate table that matches the name of the person in the main table. I can see all of the records in the view table when I do this statement…
-
Comments in Reccords
Hi can comments in reccord be called in a formula to view all comments on the reccord table example(this,comment)
-
Best way to extract specific numbered word from text field
Hi Everyone - first question, please be gentle with me :) :) :) Initial content in field Customer_description is: "NAME: Richard James (ID 230) COUPON:" I want to retrieve 'Richard' so I create a…
-
When creating a calculated formula, how do I indent to the next line in the formula?
For example, I have a field that contains: "Choose Populated Email" and once I choose a value, I have trigger after update setup, to where that selected response will populate a field I have named…
-
Multiple choice numerical output that results in more than 1 digit [ie 10, 11...etc] returns null.
Hi All, I am hoping someone can help me out on an issue I am seeing with multiple choice selection output. I currently have 4 items to choose from in the multiple choice list.…