-
Date Formula?
I need a formaula to claculate 30 days from end of month, but struggling to find a formula that calculates how to add 30 days to the end of an existing month, any suggestions?
-
immobilier
let plainPied := 'Plain-pied';let chambre := Chambres;let villeBien := text(Ville);let typeDuBien := concat(Type);let prixDuBien := 'Prix F.A.I à supprimer';let statut := Statut;let typeRecherche :…
-
want to use same data baes by group of people with diffrent rights. how many lisence required ?
Sa I have a dtabse Sales with the Cusomer Table, Inventory Table and Order Tabke and Sales Table. Now i want 4 persons with 4 different user rights, How many lisence required ?…
-
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,…
-
Why does "delete multiple fields" option not always work?
I am using Chrome browser for Ninox and am finding I can sometimes delete muiple records and then it will stop working. I am in an admin account and am in admin mode (red wrench showing).…
-
choice field color
I have created a multiple choice field where the different choices have different colors. How do I get this colors to print out in a form? they appear as just text
-
Sums and Counts based on a text status
I am trying to total the value of some invoices based on the status, like "Paid", "Overdue", etc. Ive tried some simple formulas with various adaptions and they are still not working,…
-
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?
-
Add color to line breaks and spaces
It would be nice to be able to add a color to line breaks and spacers to use them as visual dividers in record layouts.
-
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.
-
Record directly print
Ciao, With the SHIFT + COMMAND + P keys you can directly create the pdf of a table to print. Is there a key combination to directly create the pdf of a record? Grazie Valter
-
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.…
-
N of determined record
I have a table where I generate invoices and budgets. A selection field marks whether it is an invoice or a budget. How can I automatically get the next invoice or budget number?…
