Group by equivalent

I'm trying to gather records from a table with e.g. 3 fields (columns). Let's say field1, field2 and field3. The best way I can describe what I want is by pseudo Ninox/SQL like:- SELECT field1,field2,…

Views

It always creates confusion when the same word is used to describe different things. Ninox can create tabs at the top of the main window and these are called 'Views'.…

Global NONfunctionality

Creating a new database and added 4 global functions which all work as they should, but then added a fifth function which simply doesn't work. The function just has 2 'text' parameters which it…

deleteCalendarEvent

Is this possible? When I've created an event in Apple's Calendar.app, how can I later edit or delete that event? Data can very possibly need to change, e.g.…

Calendar

On the Calendar I have 2 events in May, one on the first and one on the second. When I show the Calendar in Month view for May, both events show on their respective dates - as they should.…

Filtering the table view

Often seem to have problems with this. Particularly if the column in question has 'Conditional Formatting'. I am currently trying to filter a table and NOTHING is working.…

eval(uating)

I'm trying to make a selection from a known table, filtered and ordered by fields whose names are stored in other fields (or variables). I can make it work with [eval(…)] as the filter,…

• Answered