Scripting and Functions

Clearing filters on loading a table

I use this snippet to clear the filters for a table (all). It is under a button. ui.openTableOld?null:ui.openTableOld=ui.openTable; ui.openTable = function(...arg) { ui.openTableOld(...arg); document.…

print command in html()

Hello. Is it possible to trigger the print command embedded in html() for example by onclick=ui.printRecord('{ me }', 'all')? Greetings Mirko

Change a field alignment in script

@Fred@Mel Charles@Sean Hello friends, I can't figure this thing out. Is it possible to change the alignment of a formula field to right aligned inside a script without using HTML,…

• Answered

urlOf(this) won't work in iPhone App

I have been using the function urlOf(this) to return the URL of the current record so that I can email it to a user who will need to login and update this record.…

Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month

Hi, I'm new to Ninox. I am trying to build a system that counts the number of each day of the week in each month. Example: July 2024 Mondays: 5 Tuesdays: 5 Wednesdays: 5 Thursdays: 4 Fridays:…

Ninox cannot fix email issue

Any send email function does not work. Over the past few months inconsistent operation of email function. Multiple requests fix issue but then only works for a day.…

Filter records help please

I have a table 'ASSIGNMENTS' with a field (Y/N) 'EMAIL TASK'. In my 'TASKS' table I have a formula field "ASSIGNED EMAILS" with 'ASSIGNED ENGINEERS'.EMAIL which displays the email addresses of the…

• Answered

help please on this script

The following works but not fully. None of the text: >>> Is outputted in the email. Can someone please point out where my error is. let myPdf := printAndSaveRecord(this, "TASKS"); let myName :…

• Answered

html undefined error

Hi, What in this script is causing the title error please? let myPdf := printAndSaveRecord(this, "TASKS"); let myName := "New Task.pdf"; importFile(this, myPdf, myName); 'EMAIL SENT' := true;…

How can I add additional fields to the returned array?

I want to add a newline character after each comma in an array. For example, Original code. for loop in select Customers do loop.'Customer information' end Returns Value. [116.3219065673952,39.…

• Answered

How do you create a Google map with multiple locations?

Hi, I want to integrate into my Ninox database a Google map to display multiple locations. Has anyone been able to come up with a functional solution that could be shared here or at least give me…

• Answered

Regarding 'history' issues.

I found that when using the history function (cloud-based), the backup history records were not selected for backup, so there are no previous creation and modification records now.…

• Answered

Using SNAGIT for tutorials

Hi, I use SNAGIT and it occurred to me that it could be a useful way to create user video tutorials. SNAGIT allows one to create a video and then share it via various methods such as Screencast which…

About the issue of allowing edits only when conditions are met…”

I have created two tables for employees’ orders. I want to allow modifications to Customers.text only when Orders.Salesman is the same as Customers.Creator.…

• Answered

How to locate N:1 relationships that contain data?

I have created an Orders table that is associated with three tables named after people's names. I want to use a code snippet to locate the associated tables (the ones that contain data).…

• Answered

Triggers and table conditionals limitations in Local/Cloud

Hello. I am on the Starter subscription and I found two problems: The same Trigger on create that works in any workspace (cloud) does NOT work in local (in MacBook app).…

• Answered

Is it possible to add a condition at the beginning of the table?

I am using concat here to display the data from (invoiceitems.‘1 or 2’). Is it possible to use conditional statements in the code, for example: if it returns 1, then display 0; otherwise,…

• Answered

Regarding the issue of matching records after splitting the data.

I have created three tables: "product," "invoice," and "Create." In the "Create" table, I have set up a button. I want to quickly create orders by clicking the button.…

• Answered

Argument with Ninox AI and reference field

Hi, I'm new to Ninox and the AI option is just an amazing lifeline I have an argument with Ninox AI that asks to establish a "Reference Field" when I am supposed to open from the attached…

Is there another way to display the filtered data?

I want to display the data according to the SHOW in HOME, but I can't sort it by the number of repetitions in descending order. Is there a way to use Functions to display it?

• Answered

Buttons in Tables View (Ansicht) needed

I need to have the possibility to have few buttons in the view of tables, because i want to have a list of different Students and then have a button for each day and if i press a button,…