Ninox Date and Time Issues (continued)

I have a date on a form set for January 17, 2023. I have a view looking up Transactions from a table with the filter of let xDate := datetime(Date); let xNewDate := extractDate(xDate, -6); let xTime :…

Adding record when in sheet view (all),

I have noticed that sometimes there is no response when using the '+' here or the top right icon to add a new record. Nothing happens at all and when I click the refresh for the sheet that too does…

Make/Integromat doubt

I need to automate a process with Make and I have a problem. I have created a Yes/No field and from Make I´m able to modify it. In this field I have written a code in Trigger after the change like…

Issue with creating related record from script

I have a Combox that a user can apply "Tasks" to the Client they are working with and normally that occurs from a Triggered Update within a form in the Clients Table.…

Unable to populate related table in Choice (dynamic) field

I have two tables: Category and Subcategory, each with single Name text fields. Here's the data model: I'm using these tables to populate choice (dynamic) fields in another table named Entry.…

use array or better selection query?

Hi I am developing a database to assist with followup on patients attending our hospital. I am trying to create an list of patients who were admitted during a specified date range (usually 10-14 days…

Right Justify

1: How can I right justify a text field? 2: How can I right justify the sum, count, etc., of a column in a table?

On-Premise: select + order by Syntax

Hallo zusammen, gibt es eine nachvollziehbare Ursache, warum "order by" bei einem select nicht akzeptiert wird, wenn das Ergebnis in einer Variable landen soll?…

• Answered

Creation Date

Hello everyone, I wanted to add a date field in my database, in order to have the creation date of each record. I was wondering if this date already exists within the records and if it does,…

• Answered

Simple formatting challenges

I don’t think there is a solution to my formatting challenges but they are fairly simple capabilities I figure it must be me. I am constantly struggling with things like font size for field titles,…

Dynamic select unique : can you please help me to translate this code on NINOX for dynamic selection

Mileage Chart Spreadsheet to Ninox Table

What would be the best way to put the data from a Mileage Chart Spreadsheet into a Ninox Table for look up? These are the fields that I am thinking of…Origin, Destination, Mileage.…

• Answered

Birthday field not visible in Calendar iCloud or Outlook

I'm working very often with Ninox Calendar. Syncing is very good. However, syncing birthday Fields doen't work anymore. They are visible in the Ninox Calendar but they are not in the Outlook / iCal…

Sort view by initial exam

Hi All, I have a view of all patients examined in a given month. Some of the patients have been examined more than one time during the month. How can I sort the view so that it is filtered to view…

Export contacts from Ninox to MailChimp

How to export contacts to Mailchimp? here I have 500 contacts, and it goes about 10-15

More Vieweirdness

Yesterday I decided to add some (table type) Views to a Table and then use a filter so each of the new Views showed the selection I wanted. As per usual,…

Strikethrough text in formula

Hey you guys, I have the following problem: I'm using a formula to show text in red or white colour with the "styled" code. I want to add the "strikethrough" option in order to show that the…

Sort Table by Surname in another table / show Titles as text

Hey Team, I have various tables within my database based on tblPeople. I populate a dynamic field in each of the connected tables called "FullName" based on various fields in tblPeople.…

• Answered

Filtering contacts from a specific client

Hello :), I have a Parent Table for my Clients. I have created a child table for my contacts, so I can record them under each specific client. I have linked my Parent Table for my clients to my…

Weird field/formula display on form

Anyone have an idea why this should be? Seems it only applies to this record