-
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?
-
How to unlink a composition (inner related) record?
When I change a relation field to have a property of Composition "Yes", and then save and view the field, it no longer has the unlink icon. Why? How can the user unlink the selected record?
-
Styled formula background
Having some trouble wrapping my head around how to use styled on a formula. I have a yes/no field (Flag Account). If it is unchecked, I want the formula to just use the style I've set in the formula…
-
Split in front end and back end
Is it possible to split the database in a front end (screens and program logic) and a back end (data)? When I create an application for my customer, I prefer not to import all the data every time an…
-
Bulk Update - populating linked field
I need to upate 600 odd records with a record from a linked table. How can I update them all at once to be this specific record?
-
is there a way to follow code execution?
I wish to follow the code execution but I have nothing to do that! I tried to put some alert("test1") inside some condition to test wich condition is trigered...…
-
Formulation Issue
I have a table called 'Trial Summary' with a field 'T#' that I need to reference in a formula, but I only want to reference the currently selected 'T#'.…
Answer questions and share your knowledge