About batch write Questions

我是 Ninox 的初学者，我的代码遇到了一些问题。我正在尝试将“1”中的信息一一写入“2”中。你能帮助我吗？提前致谢。

• Answered

Single Dynamic field that populates other fields

I am replacing some fields that had quirky lookups with a single dynamic field. I have a JobDockets table (related to Customers) ie N:1 - Customers can have many Jobdockets In Jobdockets Table.…

• Answered

Need Script for calculating workdays between 1st record, 2nd record, so on.

Ok, Thanks to @Fred I am able to calculate the working days since a previous record for a client. with the following script let t := this; let xBase := ('Clark Leads'.…

Spinning circle most of the time

We are having nothing but spinning 90% of the time. This has been going on for weeks--what is going on and when will it be fixed? This is impacting our work!!

Count missing dates

Hey all! I'm back with ANOTHER question. Is it possible to use Ninox to count missing dates? For example: on a timesheet I may work August 1,2,3,4,5,7,8,10,11,12,13,14,19,20,22,23,24,25,26,27,…

• Answered

How to display image in original quality?

I'm trying to display some charts made in excel (because ninox chart making is way too complicated) with an image field in a form view set up as a dashboard.…

Work out annual leave days.

Good morning. I hope you brilliant peeps would be able to help me out again please. I am working on the tables in my database for staff. I am trying to work out annual leave. I have 3 tables.…

• Answered

import duration values from Google Sheets

Hi New to Ninox but not databases. I have a sheet in GS with titles & durations of musical scores. The format are 00:00:00 (hours,minutes,seconds) how can I import those values to Ninox?…

Get the number of the chosen entry in a Dynamic Choise field

Hi, In a normal Choice field you can have a FX field that dispalys the number of the selected choice like this: number(ChoiceFieldName), then the FX displays 0 if emty, 1 for choice1,…

• Answered

Formula help

Hi to all! i am trying to activate function through a formula to open specific record. this is the formula: html("<button class='customButton' onclick='openMaster()'>Open Master</button> <script>…

• Answered

Sort json?

Hi everyone - I'm trying to create an HTML table but want to be able to sort it, probably by using a choice field that would modify the order. I can't just sort the select because one of the fields…

• Answered

Can you hide Members and New/Import/Manage tiles on Cloud Login page

I'm considering offering a Database to multiple people and I don't want them to see all the Member Names or the ability to see all the Database choices when they login into app.ninox.com.…

Bulk import images

After hours of reading and testing, I am still no nearer so am forced to ask. Using the Mac app, I want to import a (local, i.e. on the Mac) folder full of images into a simple table with an image…

.db encryption key

I need to export my data with photos to another database system. The only method seems to be to archive the database, change the file extension from .ninox to .…

Math formula with exponents

Formula for compound interest is A= p(1+r/n)^nt A=Amount, p=principal, r=interest rate, n= times interest is compounded, t= length of time in years I’m having trouble with the “^” part

Delete Files added to paper clip

I have an archive that I want to BULK delete various images attached to records. I want to keep the records but no longer need the images that are attached to them.…

Symbol experted: ")" at Line 46

@Fred @RoSoft_Steven Hi I have a Symbol experted: ")" at Line 46, column Some idea I reviewed the entire script and it only gives me that error

• Answered

How to make a dashboard display values per calendar week?

Hey everyone! I'm working on a dashboard for a database at work. We have milestone (let's call it MS_XY) with dates set, and I can't find out how to display the following:…

Share Ninox database to another account

I’ve developed a database that I would like to share with my brother, but we don’t want to mix data by adding him as a user. He has plans to open his own Ninox account.…

merge multiple print views in one pdf?

Hi NX, By using importFile(this, printAndSaveRecord(this, "View1"), xyz + ".pdf") as a "on click" action assigned to a button, a single view (View1) is attached to the record.…

Draw a line between a few points (iow draw a printable chart)

Hi all! As you can see in the picture there are a few line charts, with lines that connect some points. Those "points" (x) are generated via an if-then algorithm (if score = 19 then "x" else "-" end…

Mirror tables in different databases

Hi, Is there a system to have a copy of one database table in another database and have it so that when I add or change something in one table it automatically updates the other table? Thanks