Trigger - Update Number Field with Formula Value - en masse

Question about Triggers. Any help would be greatly appreciated! I have a table that calculates a Price formula. This Price formula is compared to a Current Website Price number field.…

A quick TIP re buttons and field formats with 3.13

I was under the impression one could save a 'style' for a button and simply paste it to each in turn. If you can please advise how but here is a work around if you cannot.…

Please check this email script

Can someone scan this to see if there is any reason why the email suddenly stopped going to me. I have added a comment at the end of a line to show what I changed.…

Complex criteria for Select

Hi, I am working on a project which requires a dynamic choice field to be populated by the results of a select based on one or more of four criteria. The criteria are selected at the top of a…

• Answered

Add/Insert record on button click

@Fred Hello, I am trying to create a new record on button click, however it is not able to find the specified column in the target table. Am I missing something?…

• Answered

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

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