-
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 :…
-
How do I view the table only on startup?
HI! I am sorry if I am missing something here, but how to I view the form with the first record right away when I open the table. For now once I open the table first thing in the morning it shows me…
-
date = Today () returns nothing. (
Hello! I got a date field. I created a formula column in that table to filter records with the date of today with a simple formula: date = Today () But it returns nothing.…
-
Mac v 2.6.9 ISSUE - RTF inline images after restart vanished
Its great that you can add images to rtf text fields but after closing ninox the inline images are vanished. Please fix this bug.
-
Bonjour Mail Groupé
Bonjour qui peut m’aider je voudrais envoyer le même mail à l'ensemble des contact sectionné dans ma table contact
-
Working with formulas
I am want to see if TABLE 1's field A is between 1 and 26 inculsive. If True, value goes into field B as new record. In "Visual" mode and using the if/then/else function,…
-
Mac Version: Are dates limited by OS X Date?
A date typed in as 1 Jan 1950 appeared to be returned as 31 Dec 1969. This suggests that OS X is limiting older dates, is that correct. In general OS X doesn't work well with dates before 1972,…
-
linking tables only using a numeric field
When linking tables if the "One" table only has a numeric field when it appears in the "Many" table it shows up as "un-named". However, if I add a text field/s they will show up in the listing on the…
-
Cant edit my Database anymore / cant save
I am trying to edit a table in Admin mode, after i made the changes I press save and than then loading icon shows up. After some minutes there comes an error message. (Server did not answered.…
-
How to change multiple dates to one year later?
Hello, I have a table that is essentially a large 'to-do list' with many fixed dates that need to be replicated every year. Ideally what i'd like to be able to do is click a button when the task is…
-
How to Format a Field?
Seems like a simple questions I know, but As a neophyte I figured out changing the date format in the table, however, the same field in a form shows up in the original date format and its not…
-
Locking records
Hi. I have a table A with many formulas, linked other another tables; B, C and D. Values in B, C and D will change, but I want to lock the records (values) that I have created in A so that these…
-
View form only
Apologies if I'm missing something obvious here but I've created some tables and forms to go with them. Until I logged in today I could view the forms without the table but today I can't seem to view…
-
Export Record, Import Record?
Is there a way to do this? I want to split one table into two tables. I duplicated the table, exported the table, imported the table, but the only data transferred was that shown in the table view,…
-
Link to view
Hi. I have three tables; Table A (top level), Table B (reference from A and additional data), Table C (reference from B with more detaled data). Data from C is summarised in B,…
-
How to Mass Create Records in a Sub-Table.
I now have packages arriving internationally and have found that they may have several tracking numbers as they move through various countries and/or carriers.…