-
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
-
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
-
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.…
-
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:…
Answer questions and share your knowledge