-
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.
-
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#'.…
-
Automatic Numbering Issue
Good Morning, I have automatic numbering working on my database but i need to see how i can improve Here is my current number . (Year - Job # - Auto number-001) 2019-522-001.001 2019-522-002.…
-
auto-populate table from data from another table?
I have created a database, Pupils, Class, Registered Class Pupils, Session Occurence. 1 Pupil can take many classes (via the registered class pupil table).…
-
popupRecord
Hello friends, how can I make a new recording with this, but in a specific view formular ? (Not popup) let myNew := (create Interventions);myNew.closeRecord();popupRecord(myNew) THANKS.
-
How do I prevent table from update?
I have some article and price. I have some client that have purchased some item and I wish to prevent that if I change the price of this item, the client paid price will also change according to new…
-
Suggested mobile browser emulators?
What is a good way to quickly see how a Ninox solution looks on the various devices and browsers? I just tried http://www.mobilephoneemulator.com/. Is this a good option,…
-
Formula Help Needed to Hide a Space Field Layout Element.
What would the "display field only if" formula be to hide a space field element? I need the space hidden when "Active" is select in my chosen field name Status.…
-
Is it possible to drag a message from Outlook inbox to add as an attachment without having it delete the message from the Outlook inbox?
When I drag an message from my outlook inbox to the file attachment tab of a database record it deletes the outlook message from my inbox. Is there a way other than saving the outlook message first…
-
How can I attachment multiple files from related tables and email them?
Hello, I've built a system to help us track orders for oversize / overweight permits. Once we get the permits back, we upload them to their associated state,…