-
Sum a field based on a multiple choice field
I am trying to sum a field based on the value of a multiple choice field, ie = 1, 2 or 3. This works for values 1 and 2 here sum((select 'Personal details')['Bond/Insurance Provider' = 1].…
-
How to sort concatenate values from linked table
Hello, got hard time in order to find a way to order concatenated fields from a linked table. In short I have to create a report from main table that use a linked table to feed a grid with "Note…
-
change the labels on search
hello, how to configure the labels that appear on a search? thank you. alain
-
integrated Google Maps Formula.
Good Morning All, I have a formula in pleace in which im trying to add an option for to select if i display a pin location on google maps by either, name of the business, the street address,…
-
Pre-Populate Choice Value List
How can I pre-populate a choice value list (Year) based on another choice value list (Make) selected? Ex: Make, Year, Model Thanks,
-
Deleting Images via batch update or formula
Hi, I've noted that when using the formula : Image := null , rather than deleting the image it shifts it into the attachements area. Is there a formula which will delete the file?
-
Contains formula
What is the formula to display something if it contains a certain text in that field?
-
Create un subtable record from the parent table with a script button
Hi, Need help... How can i do that please ? Thanks !
-
Deriving dates
Hi all! I am looking at projects. I have different phases and duration for each of those phases, which vary per project. My first phase is definition. And my second phase (configuration) cannot start…
-
Should I be able to send formula fields from Ninox to Gmail using Zapier?
I can get text and number fields from Ninox to transfer to an email via Zapier but I can't see data created via formula fields. Should these fields be accessible to link via Zapier?
-
Add color to a line break?
Is there a way to add color to a line break? I want to have visual dividers on my record view. So far, all I can do is a hearder with no text workaround.
-
left pad How to use
I understand substring, but cannot get left pad to work.
-
Different colours in Calendar
Hi, I have created a database that lists Composers their Compositions. Both contain date fields, that I have set to appear annually in the Calendar: - Composer:…
-
"Like" and "not like" formula selection?
I want to create a formula that performs an action if a certain value is selected (like) in a choice field, or if a certain value is not selected (not like) in that same choice field.…
-
Icons in Choice
Hi, how can I add custom icons to choice buttons? I see posts from 2018 saying it will be in the future. I hope we are in the future now.
-
Keyboard input for decimal
Hi, this may be a stupid question. On my laptop the decimal is a comma and PC the decimal is a fullstop, how can I get that they are both the same.(MAC).…
-
Calendar and ical Synchronization
Hello, I downloaded Ninox for individual use and installed it on my macbook pro. I've just created my first database: an organizer for my business tasks.…
-
Button delete all record
Ciao, How can I create a button field that deletes all data in a table record? Thanks for your answers Valter
-
Sum on a print view
Hello, Hope someone will be able to help me.. I'm working on my print view. I have added on my print view the view element called 'Estimates' (See picture below).…
-
Mac App and iCloud
Hi, I've purchased the software, and i do want to synchronize with my iPhone and my iPad, but without using your cloud to i still need to register ? The app for iPad looks like the Mac's software,…
-
Why is Formula Editor changing my variables?
I'm writing code to create a new record in a Clients table and copy some fields from the current table. The editor is changing a variable and causing an error.…
-
Hilfe bei Tabelle für Assetmanagement
Hallo Liebe Ninox Community, ich bin ganz neu hier und hoffe ihr könnt mir weiterhelfen. Ich bin gerade dabei eine Tabelle zum Assetmanagement mit Ninox aufzusetzen.…
-
Separate multiline text field into individual rows?
Hello! We're beginners in Ninox and want to build a database to manage a book library. We think we can use the Ninox template "Inventory" and adapt it to our needs.…
-
Date and Hour Format
Hello I have a problem that I hope can be solved somehow. We are integrating Google forms to Ninox thorugh Integromat. The problem is with date and hour fields since the format used in google forms…
-
on which database is Ninox build
On which database is Ninox build ? for example mysql ?
Answer questions and share your knowledge