-
display problem!
I have this formula to display data on a field... let t := this;(select Prix)[number(ID) = t.Achats.ID_prix_1].Prix and it wont return something. It appear to not interpret the ID_prix_1 as number...…
-
Size - Colors - and other variables
Hi is avalaible any template or demo for create product with variables Like size: X M L XL etc.. Color: red white black etc..etc.. and/or other type Thankyou
-
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?
-
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,…
-
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
-
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.
-
Use a number in a choice field as a multiplier of a number field?
How can this be done?
-
Show Date as Year Only
I have a date field named Vintage. How do I format it to only show the year, like 2008?
Answer questions and share your knowledge