-
How to do calculation on sum.
Hi. I wondered if it was possible to do anything with the built in sum. I was wanting to take 1 sum away from another to get a balance. Or is there a bit of code to sum 2 fields eg credit and debit…
-
How can I tell what version of Ninox I have and get updates?
How can I tell what version of Ninox I have and get updates? Currently running Ninox on my Mac and iPhone.
-
Aprire una tabella con filtro
Salve, è possibile mediante una formula aprire una tabella con relativi filtri?. Esempio Da un modulo cliente, mediante click su un pulsante, apro una tabella per visualizzare tutte le fatture del…
-
Not asking for tech help but...
I've come back to Ninox after approx 1 year away and holy crap I have forgotten SO MUCH. I'm trying to do a simple display if formula and I'm so lost ahaha. I'll pick it up again soon.…
-
I have a formula that shows me hours worked for an individual day, I want to make it so that these are all added up for each week from Monday to Friday showing me the total hours worked that week.
I have a formula that shows me hours worked for an individual day, I want to make it so that these are all added up for each week from Monday to Friday showing me the total hours worked that week.
-
Get image URL via REST API?
Is there a way to get the full URL for an image field via the REST API so that I can load the image?
-
I have 4 tables (Employees, Jobs, Customers, TimeSheet), I need to constrain the employees to only see Jobs they are signed to. I also need to be able to sign each job a customer so they Jobs can be attached to a customer for billing.
Constraints for Table Timesheet Field Customer (Customer table is referenced) a.employee.name=a.customer.name=a.job.name Constraints for Table Timesheet Field Job (jobs table is referenced) a.…
-
Trigger - use data in table 1 to create line in table 2
Hello, I am struggling to create what I think will be a trigger event...? I have two tables - Components and Purchase Order. What I am trying to achieve is the following: 1.…
-
I've just imported our company date (14 years of sales and customers) and I used the default "field type" settings. Now I realize that some of the field types need to be changed, for example one field was a date field imported as text but should be a date field. Thanks.
I've just imported our company date (14 years of sales and customers) and I used the default "field type" settings. Now I realize that some of the field types need to be changed,…
-
"Display if" question - multi conditions
What expression should I use if I would like display field A in case: if field B is filled then field C also should be filled ?
-
Not saving new info
Hi, I've recently noticed that my ninox iPhone app doesn't always saved when I update some info in an entry. This is extremely worrying as I just trust it's there and forget about it.…
-
Server not responding error in Ninox... pls help!
Hi there, for the last few hours, in our Ninox trial account there is an error that keeps displaying, 'Server not responding. Please check your connection.…
-
How do I print a multiple page data form?
How do I print multiple pages?
-
Display a field 1 hour after record first created
I am doing a quiz and want to make it so the calculated % Score field will only display 1 hour after the user clicks Now in a Date / Time. They enter the date/time when they start the quiz.…
-
Calculate an amount based on a Number field and a Multiple Choice field
Context. Trying to populate a table of days of the month from a 'Costs' table that has known costs of the business. Costs table: Day is a number field. Months is a multichoice field: Table looks like:…
-
Merging more columns into one
Hello, i`m new here and have no tangency with IT, so all the help is welcome. Issue #1 I have 2 tables : 1st with clients Name, Surname ; ( called Clients ) 2nd with the followin columns :…
-
Logical Functions
Hi, Do your calculations support complex logical functions i.e. If 1 then a else if 2 then b else if 3 then c else d
-
How to copy a record from email field to another email field
Hello everybody, I need to automatically copy the email address entered in the main tab to another email field inserted in a subtab. It's possible? I tried with a trigger but it doesn't work
-
Filtering on Summed Value
I am currently using the Ninox Database to store inventory and store their locations in the warehouse. I have a transaction table that stores inventory purchases in (with positive value) values and…
-
Copy table (t1) and subtables(s1 and s1.z1) from other table (t2) and subtables (s2 and s2.z2)
I want to copy T1 and all its sub-registries from S1 and Z1 in to tables T2.S2.Z2 I can copy S1 to S2 but I don't know how to copy table z2 related to S2.…
-
How do i copy a drop down list from one database into another one?
How do i copy a drop down list from one database into another one? Without having to create it again in the new database manually.
-
Trying to write basic mathematical formula for Inventory
I need a sum so that the display shows the Remaining Stock Fields are currently numeric for "Number" and "Supplied" eg: Number = 50, Supplied = 3, so Remaining Stock = 47 I had:…
-
Date Field Format
I am compiling a database for the large number of subscriptions I maintain. How do I format the following: 1) A field that only shows the date of the month that monthly subscriptions renew? Note:…
-
Relazioni fra Tabelle
Salve, come posso impostare una relazione tra due tabelle, ovvero, vorrei inserire i valori in una e ritrovarmeli anche nell'altra.....Grazie mille
-
Can I use the Sum from a list of formulas in a view table to create a new formula
I have a view table in a form which is based on a date range. I want to add a formula on the form which shows the result of two values, in this case "Franchise Fees" from the sum of one of the…