Single page formatted print of all records in a table

I have just started trying iPad Ninox (after around 20 years of using MS Access) and am generally very impressed. However, I need to produce a nicely formatted single page printed report containing…

possible subform fault - just a warning

Possible subform fault! - just letting you users know!

How to pick up single value from related table

Excuse my ignorance but I am new at this. I have two tables, the first table is called 'Paper Catalogue' and is a list of items and their prices. The second table is called 'Calculation' and has a…

select not working

The following is not working as expected (I think). (select Table1)[Id < 50].Col2; Table1 is a table with a few records, some with Id less than 50. Col2 is a text field, filled with some text.…

Disable the create record on the left

Hi :), Is there a way to disable the cross button on the left to create a new record in order to just use the create record cross on the top right?

SQL to sum the sessions for only the current month

Hi, I have this code behind a button and when I click it I want it to populate a table with various information (which is partially working) let me := this;for i in select Pupil dolet myInvoice :…

Limit view to sessions scheduled for next month

Hi all, I have this form which is a reference to another form - all I want to do is for it to show the sessions scheduled for next month, I know I need to use the month function but I'm not too sure…

Console to test sql/nx statements

Is there a console or someway to run arbitray nx/sql statements? I'm finding the nx script a bit confusing and there's not any way I can see to preview statements to see their result outside of…

I am making changes but Ninox isn't asking to save them

I am making changes to a formula field but, after clicking the OK buttons, Ninox isn't asking for the changes to be saved and the amended formla is being ignored.…

Conversion

Any help on how to convert my Database.ninox back up into a CSV file ? ie From ZIP to CSC or XL file so I can import the data elsewher

How do I express a date to a day, like Monday or Tuesday. Other than using a choice box with a dropdown list. Thank you

Thank you for considering my question

Table within a record of other records in the table

Is it possible to create a table within a table showing other records from the main table that have the same field? So in Record with ID WEV0001216 I would like to have a table of all other records…

How to make a multi-level dynamic drop-down list ?

How to make a multi-level dynamic drop-down list? Thanks.

Printing TAG for inventory

I am creating a workshop inventory, it will include tools, but also hardware, like bolts & nuts, washers, drill bits or paint, brushes and various stocked material, metal, wood, etc...…

Formula for a Button

Hi :), I'm trying to make a button work but can't seem to figure out the correct formula to use. I record for each of my clients their payment terms in their profile.…

iCloud is not syncing.

My desktop databases are set to be in the cloud, but thery do not appear on my iPhone or iPad. What is the fix?

Why is my switch statement always returning the default value.

Hi all, I have the below code attached to a button, when i click the button it should used the choice from the drop down to append the suffx to the filename before saving it into the attachments.…

Create new record whilst inside subtable

Is it possible to create a record whilst you are already in a record of a subtable? The record in the image is from a subtable I would like to select the record and with the reversal,…

Access a VIEW's data by a formula in another view/table/field

Is there a way to access ONLY the data inside a certain view within a formula? If so, how do i do it? I am working on a leaderboard and have battles/players/events as tables.…

How can I fix the fact that you can directly click on a record with your phone instead of going to the whole sub table first?

On pc, if you click on a record of a subtable, you will directly access the record. On the phone, this does not seem to work. It looks like you first need to go to the sub table and after that click…

Hiding Fields in the app version

I would like to have all fields visible on my desktop for admin users. However, people out 'in the field' using the app, do not need to see some of these fields.…

How do I remove a link between two tables?

I can see that I inadvertantly created links between two tables. How do I remove the links?