Relationship between 2 tables - how to?

Hi I'm a musical director with a choir. I need to track which songs are going to be sung at each rehearsal. So I have created a table with all the songs:…

Split Function Help

hi to all! I have got this tables in Ninox: TABLE: Genres Field: Genre TABLE: Masters Field (in error): Genre The field in TABLE Master can have 1 or more Genres,…

• Answered

Control panel data check

Hi there. Not a coding question as such. @Fred has mentioned using control panels to enter data into the database which I am researching. I have watched the Nioxus videos on this and can see that it…

• Answered

Double action button

Hello everyone, I've created a data base witch manage software licence subcriptions. I've added one button that allows to renew the licence. I want that button to add one year to the end date…

• Answered

Is there a 'command' to delete an attachment?

I want to have a button that can delete a file attachment (paper clip). Does it exists? I am aware that this might not be possible given there could be more than one attachment but worth asking…

Open Record based on UserName

Good morning! I am trying to make my database more user friendly and was wondering the following. I have a table called Timesheet. I have a dashboard too.…

• Answered

About code Questions

上面的代码出现了问题，数据变得一样了。 “物流码” HTTPS://M.LZLJ.COM/R/122169506032380086 HTTPS://M.LZLJ.COM/R/122119277562447981 HTTPS://M.LZLJ.COM/R/122121718875948831 HTTPS://M.LZLJ.COM/R /122179735097552622 HTTPS://M.…

• Answered

select where statement.

I have two tables, MANUFACTURER and INVENTORY (1:N) In the Inventory table I select the Manufacturer - so far so good. I have added a view which I want to use to display all other inventory items…

• Answered

Two Serious Problems... Required Fields & Trigger on new record/update

I just realized there are two serious problems that might be deal-breakers for my business. 1. Required fields don't seem too required. That is to say, I can close a record and it saves (because it…

• Answered

Please teach me how to use this global function :-)

This code can be used in global functions and I want to make use of it. I know I can call it from a Form/Tab as needed but how? "--- This controls the HUD icons top right ---";…

• Answered

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