-
Trigger YES/NO formula if value already present in DB
Hello, my records contain telephone numbers of clients and i would like to know if the phone i enter has alredy been used in the past. This to understand recurring clients.…
-
Duplicate a record and killing related records etc.(oh and jumping to that new record)
Using Ninox“s build in duplicate a record is great but it does a complete clone of the original record... Which often is fine but... it does not re trigger say a sequence number field and of course…
-
Print on Button Click
Is there a way to print on button click or is the PDF printer the only output from a button/print command? In other words has a direct print function been developed or are we still tied to the "old"…
-
Formula help: Make enddate empty after accomplishing task
I“ have made a simple but for me efficient Projectmanager in Ninox. The enddate for task. is linked with my calender. However, due to a lot of tasks my calendar becomes overcrowded.…
-
can you sync a database with the Contacts app?
if I have a database in Ninox, can it sync with Contacts, so data that is updated will be reflected in the Contacts app?
-
Update multiple records with a calculation
Hello I have found “Update multiple records” very useful so far. I“d now like to update a field which is a reference to another table using a calculated value. Is this possible? If so...…
-
Extract values out of Array from JSON
Hi all, I have an array from JSON which i get from text(response,result) { cost_per_km: 0.003, cost_per_mi: 0.004, 20_80_charge_Level1: “1:00”, 20_80_charge_Level2: “0:23”, 20_80_charge_Level3: “0:…
-
Is it possible to turn a multiple choice field into text with values separated by a “|” ?
Hello I am working with a website developer who is trying to integrate my ninox database with woocommerce via zapier... one of the things we need to do for zapier to read ninox is turn multiple…
-
Styled doesn“t keep text styling?
I have the following code:let d := Date;let rowText := join((select “Doc of Truth”)[“Magic Piano” like “Spanish” and Date = d].“Raven_id / Perf_key”, “”);styled(text(rowText),“”,“red”,…
-
Print Layouts - Cloud - Text(multi) and Rich Text printing issues
On the print view via Cloud my Rich Text and Mulit Text boxes retain the proper formatting. When I print to PDF, they lose the “end of line” or carriage returns.…
-
many to many link
Hi there I have 2 tables and when I link 1row from the table that row is not available to relink any solution to help me fix this? Table 1 = Company Table 2 = Client Now each company has multiple…
-
How do I count number of choices selected in a multiple choice field?
I included a multiple choice field with six choices; each choice is labeled with a Board Member“s name. I create another field (Approved) that indicates a count of how many ofthe directors have…
-
formula to count unique records
I want to write a formula that counts to number of rows based on a unique field (Id). E.g. table ID Date Amt 1 2/2/2020 100.00 2 2/1/2020 100.00 1 3/1/2020 50.…
-
Formula to combine address fields?
How do I add linebreaks to a formula field so I can combine separate first name, last name, address, city, state, and zip code fields into one field that looks like this:…
-
I need to copy one date field to another but only the first time the source field is populated... how / is this possible?
I“d like to copy a field called ”Listing Date“ to another field called ”Original Listing Date“, but only once (the first time that ”Listing Date“ is populated).…
-
Timecard employees
Hi, I have two employees, the first works 8 hour per day monday to friday (simple), the second works 4 hour per day except Wednesday that works 8 hours.…
-
Confronting the spam bots
Hey guys, I saw that one of these ads in the forum had a live chat, so I talked to someone on there regarding the big spam in the forums. Hopefully they can do something about it and not ignore the…
-
Issue with ID
Let me better explain: I have created a formula formula to order my price quotation that goes like: “AR” + ID + “” + yearmonth(today()) + “D” (result this month:AR12020/11D).…
-
Would someone please tell me what i“m doing wrong here?
I“m using this formula: let Open := select Tracker where this(Symbol) = Symbol and this(Expires) = Expires.Total; Total + Open First problem is that i get this message: ”End expected:…
-
Sequential numbering
I“m trying to get each entry on a suitable to be numbered 1-2-3 etc each time a new instance of the subtable is created. So, the main table represents a ”Job“ and each entry on the subtable…
-
Custom layout for Cards view
Is there a way to remove the field labels in Cards view? I don't need to see Name: The name. I just need the field data displayed. Also, I have a multiple choice field,…
-
Calendar Name/Title selection
My items are appearing in the calender however can you control what the “title” or event name or what you call the short display name? I usually get a combination of fields which can be unobvious…
-
Selecting date from does not appear to work only for November 1st, 2020
There are many instances in the app where we need to select the previous date“s entry and populate - Example; populate with yesterday”s meter readings. Originally,…
-
Move to field using Trigger after update
A simple I know but I'm brand new at coding in Ninox. I have a field 'Manufacturer' and a field 'Model Number'. I pick a manufacturer and then the model number in two steps.…
-
Import keyed on multipl linked fields
There is a Table 1 “Responses” that refers to Table 2 “Clients” and Table 3 “items” and has a text field “Response”. I want to import data in to the table “Responses” that has Client_Name | Item Name…
Answer questions and share your knowledge