-
Suggestion - Storage Summary
Hi, I'd find it useful to know which tables within a database are using the most storage, to for example know where we're getting the most file attachments placed,…
-
Mac Application Slow Performance?
Hi all, I have a database of my personal finances in which, along with the tables that hold the data, I have about 15 tables with reports (depending on the group and category of expenses).…
-
Print tableview
Is it posible to modify printout of the tableview in with modified number spaces it should be like XX XX X XXX XXX. Each partnumber has 11 numbers it shoudl be in this form not like XXXXXXXXXXX.…
-
Hide field from all except x user group
I want to add tabs to my forms for "backend" information that ties into our dashboards etc. Is it possible to hide them from everyone except in the "Admin" user role?
-
chart view problems
Since two days ago. Im having problems with chart.
-
QUERYING VALUES IN A SUBTABLE
I have two datasets - Leaders and Media - in a 1: n relationship. I'd like a f(x) field in Leaders to check the Media files linked to a Leader file and return a value (Available / Unavailable) based…
-
Is it possible to delete a file using a button element?
I’m using the code below to create a button that generates a report and attaches the PDF file to the current record: let pdf := printAndSaveRecord(this, "Employee Schedule Report”); let name :…
-
How to subtract a column sum from another column sum in another table.
Good Morning I have 2 tables, money in and money out. I have running totals summed at the bottom of each cash column. I was trying to take the money out away from money in total to get a balance but…
-
New View/Form? What is the purpose of this view?
I'm having a hard time seeing the value of a New View, Form. All that I can tell it does is hide the records column on the left side. Any changes made to the Form are reflected in every other…
-
on update formula with multiple choice seem to work only when select an item not unselect...
If I unselect an item, nothing happen until I select one... Is there a way to make it works?
-
New Recording in a specific view...
Hello friends, how can I make a new recording with this, but in a specific view of my choice? let myNew := (create Interventions);myNew.closeRecord();popupRecord(myNew) THANKS.
-
Rolling 12 month average
Table Fields include Organization name (Table ref another table for organization name.), then date and invoiced$. I would like to be able to show the rolling 12 month average for invoiced$ for each…
-
version 2.5.8 and over?
Hello evrybody, 1. What is new in the version 2.5.8? 2. It is planned a new big update version nextly? 3. It is a way to be beta tester of new version? Have a nice day. Robert
-
Button Formula - Duplicate Record + sub-records
Hi all I've got the formula almost down-pat to duplicate a record: let reply := dialog("", "Do you wish to revise this BLA?", ["Yes", "No"]);if reply = "Yes" thenlet currRec := this.…
-
If field = null then 1
Honestly, this is going to be so obvious but I just cant figure it out D; I have a number field "Version" I want to create a trigger after update formula that checks if "Version" is null,…
-
sFTP server
Hello, Would like to save our data on a personal server. For example by sFTP. iCloud is maybe, secure but... Not the best for privacy. Thank you.
-
Record Archiving or Hiding
I can't share a picture for legal reasons, so I will try and explain. I am using Apple version of Ninox. I am managing thousands of engineering documents.…
-
I have multiple operation for on update formula and it wont work!
I have: let t := this;let m := (select Contact).Addresse[number(Contact.ID) = number(t.Contact.ID) and actuel = true and text(Label) = "Maison"].ID;let t := (select Contact).Addresse[number(Contact.…
-
Find Screen?
Where does Ninox pick up the column headers from? My table does not look like that, nor do any of my views.
-
How to use ‘modified on’ to display the data modified by the global today?
I have a few questions. 1. Can 'modified on' show only the date and not the time? 2. How to use ‘modified on’ to display the data modified by the global today
-
Linking Tables/Records
I uploaded a database named LinkTables that demonstrates how you can link records based on like fields in different tables.
-
problem returning an ID
I have the formula: (select shipping)[actuel = true].ID and It return "0" nor nothing but if I change the .ID to another field, it work perfectly! I tried with number() but nothing work... Thanks!
-
converting trail database
I currently have a trial database, how do I convert it after signing up for the actual program?
-
Coping Multiple Records from One Subtable to Another
I have table named 'Trial Setups' with a subtable named 'Tech Sheet'. I also have a table named 'Generic Setups' with a subtable named 'Generic Tech Sheet'.…
-
function duration*value/3600000 returns different results in form or table view
Why result of same function duration*value/3600000 appears correct in table form view and return result "0m" in table view? Tks.