-
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
-
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…
-
how to update a field when moving trought records?
I'have a field in my form and want it to reset its value every time a move to another record. How I could? Thanks
-
Why does your manual have so many spelling errors?
Your manual has many, very obvious spelling errors, such as “Costomers,” “Show Comumn,” and "Cklick." Why haven't you used a spell checker, let alone a proofreader? This is very unprofessional,…
-
Trigg 'create table' and automatic link between table
Hi all. I Have 2 linked tables 'Projet' and 'Planning'. I wanted to create a trigg record on 'Planning' when i add a new record on 'Project' and copy/paste some informations (like date, object).…
-
Format Date
Hello, I would like on my form to display the date format as follows DD / MM / YYY and not DD / MONTH / YYYY.So that when we do a copy paste we get for example 13/05/1937 and not 13 mai 1937 Do you…
-
To change the style of the name of a field ? (Color, size…)
Hi Can someone tell me if it is possible to change the style of the name of a field and the way to do it ? Thanks
-
How to add photo with a button
Hi I want to be able to click a button and this will enter the same response as adding a photo image. Help appreciated.
-
Buttons
Hey, Does anyone have code for adding an image to an image field via clicking a button? Thanks.
-
How can I unpivot data from columns to rows?
I have many columns as % Wood, Metal, Concrete etc. I would like to pivot these multiple columns and convert these to rows in one column called "Material Types" Is this possible and how? Thanks!
-
Using trial version
Why are print, delete, duplicate icons disabled on list view? When I select 'Print View' how do I set the destination folder? How do I print a list of a found set ie:…
-
how to display field if?
I have a choice field called "client type" with values "individual" and "corporation" If "individual" choice is selected, the display fields "first name" & "last name",…
-
"Display field only, if" with multiple choice
Hi! I need to show field if some options of multi choice was chosen (one or two or even three) I tried to use chosen function: chosen('multi choice field') => ["Option 1",…
-
Is there any way to manage data from Ninox in Excel?
For instance, I would like to create a dinamic table in excel retrieving data from Ninox. Thus, I must not export continously to excel and start building again connections.…
-
Home screen layout
Was just wondering if anyone had good idea of a home screen dashboard etc with maybe wee menu to goto views etc and maybe a bit of text to jaz it up a bit. Or even using the connector thing.…
-
Different behaviour Mac OSx app versus via Chrome websbrowser
Hi, I am struggling with different behaviour of below code in Mac app versus web version in "trigger after update" of a number field in a form.Using the Mac OSX Ninox app,…
-
I would like to show the count of each multiple field together in a chart.
For example, if Record 1 has choice "A", Record 2 has choice "B", and Record 3 has choices "A" & "B", the groups that I am getting are: A - 1 B - 1 A,B -1 I would like to get: A - 2 B - 2
-
Move record.
Is it possible to move a record to another table depending on a selection field ie yes. And remove from original table. Thank you.
Answer questions and share your knowledge