-
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?
-
Import of Mac Contacts to Ninox - what´s next... with CRM?
I am tiny sole trader. I want to use Ninox to organize orders, invoices, contacts etc. I have a question regarding using contact from my Mac. I have imported my Mac contacts with the template…
-
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:…
-
Cards view cover photo
I have records with images at the top. In form view, I can edit the Image field to select “cover” as the image display type. Is there a way to do that in Cards view? In other words,…
-
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”,…
-
Idea
Add the possibility to open/close the full screen for a particular tab. It would make more usability while making dashboards
-
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:…
-
Multiple Choice Facts
Because a Multiple Choice field is quite complicated to extract values from, these are just some of the things you need to know. Check MultipleChoiceFacts in the Webinar EN 2020 team. Steven.
-
Set an alarm for a date?
How do I set an alarm or get a notfication when a date occurs? I want to be reminded when someone owes me money sometime in the future.
-
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:…
-
Another undocumented operator : %
Also not documented in the reference manual: For example: 5 % 3 gives a result 2 which means the % operator gives the remainder of the division. Steven