-
table relation suggestion
This is my first approach to the databases and although I think it is a very intuitive application, still can't get the result I want. I made a "materials", "items",…
-
User restrictions
Hi again. Sorry about all the questions. I understand that I can restrict user access on record level (write, read etc) but can I restrict changes to the actual tables?…
-
Remove all white spaces from a string
Hi, I need to know is exist a formula to remove all white spaces in a string. Trim just removes from beginning and end of a string. Thanks.
-
How to account for holidays when calculating workdays?
Assume we are using the Project Template database.. A Project has a Beginning and an End function field that pulls the min / max of subproject dates. I added a Holiday table that has a HolidayDate…
-
Is that possible to fix the header of Ninox app on Mac OS?
It happens a lot that we want to move Ninox app to other side of screen and resize that and it selects all text and images we have!!! Thanks
-
Many-to-many referenced table magnifying glass, what is it supposed to do?
I click the magnifying glass icon and a blank list appears. What is it supossed to do?
-
When import data triger update not working
Hi, a bit of a frustrating problem I have is when importing data it does not trigger the event in the field that the data is imported. How can I ensure that the trigger event happens?
-
Update field values
I have a values one one field that I want to bulk transfer to another field - how do I do this? Many thanks
-
Default Email program
Hi How do I change the default email program linked to the email field? Many thanks
-
Help! I just erased an important contact
I just erased an important contact that is linked to many tables, is there any way to get it back without restoring the complete data base?
-
Is there any way to copy a value list (US States) from one table to another?
I do not want to have to copy and paste all 50 states into another table. Is there anyway to just export or copy and paste fields from one table to another to recreate the field? Thanks.
-
Ninox Update
Hey guys, I was wondering when is the next big ninox update? and whats going to be in it? (if you can talk about it that is) Thanks!
-
Is there a way to order the "Many" list when making a selection?
Perhaps best explained with an example: I have a table with a list of objects I have another table with a list of specific dates I've linked the Objects (1) to the dates (Many) When I click on the…
-
Inserting a line in a table
Hi, how do I insert a line between two records in a table. I have a client thats head is deadset that he needs to insert a line between two records so he can easily input data manually from a hard…
-
How do I index an entry
Could someone explain how to ensure all entries are indexed.
-
Create tables with autonumbering with ease.
Since i see a lot of questions passing by on this forum about autonumbering I desided to make an template with a little different approach. Just posted it in the Webinar EN 2019 team.…
-
Iteration
Good Morning: I have a problem performing calculation. I need to make a database with the stock of my references. These are located in two warehouses. If I use functions everything works fine but…
-
Multiple rendez vous
Bonjour, Je cherche une solution dans le calendrier rendez vous, pour pouvoir selectionner plusieur date de rendez vous.... Merci d'avance pour votre aide
-
how to add auto numbering
How do I add auto numbering to records on creation please.
-
Is the Guided Tutorial Broken?
I am getting a loop showing stuff already completed, cannot proceed and when I do click on something I get Lorem Ipsum. See attached? Clicked on 'Create a Table Reference' and the following displays.…
-
Leading zero's in a number field
I am trying to format an invoice number field to have leading zero's with the following lines: format('Invoice #', "0000");let i := number(max((select Invoices).…
-
Changing the global unique Ninox ID
I am transferring from Filemaker to Ninox. In Filemaker I used the unique ID to generate another ID, which I use to identify my artwork (e.g. ArtID 50240 which came from the unique ID 240 + 50000).…
-
Is there an easier way to convert a payment choice into a number?
OK - I have a choice field that lets you select 29.97 or 39.97 or 49.97 I then have a formular field that contains code: if 'Chose Payment Amount' = 1 then29.…
-
Condition where
Hi again. I am still trying to get my head around conditions in Ninox. I have a field (sum from another table) where I would like to restrict which numbers are being added in the sum.…
-
Chart monthly
Hi, i make a little database for income and expense and i want to show in a chart monthly incomes and expenses. Like january, february.... For now i have only a formula :…