-
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,…
-
Formula to select a tab in form view
Hello, I have a formula to put in a button to open a specific view. But, I would like to have a formula to open a specific tab within a form view. Thanks in advance for your help.…
-
Display field only, if: either of two other fields has no data?
What is the formula needed to make this work? The field names I want to check for data are titled Email 1 and Phone 1. I can make the field hidden with either 'Email 1' = null or 'Phone 1' = null,…
-
Admin Access Privileges
Is it possible to give access to edit certain tables within a database, without allowing access to other tables
-
Color of formula field
I want to be able to change the colour of a formula field while displaying the result of the formula based on conditions. Example. Red if result is less than 0 and green if result is greater than 0.…
-
Image sharpness
Hi , i am finding that images attached are very blury on the display field . it that they way it should be or there is a way to fix that? (same with pdf)
-
View
Hi, I have two tables. the first one is a list of purchase order (PO) with date, suppliers, amount, season market, price and total per order. the second one should be the dashboard.…
-
How do I delete a 'Team' tab from the top of a Database?
At the top of a Database, i have three tabs....one says 'My Database' the second says 'My Team 1' and the third is '+New Team'. can i delete the Team tabs?
-
How to compare dates in Ninox?
What would a Ninox formular look like that compares a 'current date' field with an 'expiration date' field and shows the word "Expired", if 'curent date' is equal to or beyond the 'expiration date'?
-
How to use rpad() and lpad()
I have 2 fields named LastName and SocialSecurity. I am making an ID field using the first four letter of their last name and the last 4 letter of the SS #.…