Fred's Profile | Ninox Community

Badges

Latest Posts

A new version and no release notes, again.

Just got informed from the Mac App store that there is a new version of Ninox for Mac. It has been upgraded to 3.7.8. But, of course, there is no info about what has changed.…
- Fred
- 3 yrs ago
- 82
- 2
- Learn and share
Re: How to create a field that displays all gigs worked within a range of dates?
@Rafael said: In Dasboard table I place one tab with the name table is a table in HTML look very good but don't know integrates the event_staff_join to see the staff Name, is possible ?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Show form of combined select (or array) logic
@Thomas said: Well if I do: let a := (select table_A where bakery = "" or bakery = null); let b := (select table_B); let c := a[(var t := this; count(b[email = t.email and telefon = t.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Show form of combined select (or array) logic
oops forgot that part. sadly Ninox won’t display the results with just c since these are the results of a select you need to tell Ninox what to do with the results so you would have to write…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Show form of combined select (or array) logic
So records in A have email and telephone numbers fields to match? You could do something like: let a := select table_A[bakery = null]; let b := select table_B; let c := a[(var t := this;…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Jacques TUR You are a funny man, Jacques. Oh and a pretty good programmer to boot.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: NEW: Dynamic print layouts for public cloud
Sadly it sounds like they will not be making any major changes to their own print engine so for us app users we are left out. :(
- Fred
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Jacques TUR Nice! That is a quite an impressive update.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: How to create a field that displays all gigs worked within a range of dates?
Made a mistake in the first DB. This new one fixes the issue. The first one was using the Staff table which brought up all events the staff that was found worked at,…
Attachment
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Read Data from Tables without creating manual Links
Take a look at the attached DB. It is very basic but it should point you to the right direction. If you decide on this path then we can talk about how to script the linking of all your records.
Attachment
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Ninox Not Responding At All
@Phil I would say to contact Ninox as I run v3.7.7 on my 11.6.7 MacOS and do not have exhibit this issue.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Problem of managing automatic record creation with trigger on the Ninox Mobile App
can u upload a sample of your DB?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to create a field that displays all gigs worked within a range of dates?
you can download the file, unzip it, then in the browser click on import archive and then select the file you downloaded.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Constraints - Please help!
@Benoit FABRE this is an old post. please create a new post and we’ll try to help.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to create a field that displays all gigs worked within a range of dates?
You may want to think about a dashboard. I have mocked up what it could look like in the attached DB. If you open the dashboard table you will see what it looks like.…
Attachment
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Count number of fields containing zero
@Chris Thomasson said: I just know that I must have been on Hometime, if the following pay period has zero miles. In a way you are tracking Hometime. You can filter out pay periods with miles !…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Count number of fields containing zero
@Chris Thomasson said: However, I would also like to see the avg of x weeks, excluding the weeks that I was on Hometime. How is Hometime tracked in your DB?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Adding and removing items from a list
Since you have kept everything in arrays, very smart move, you can follow the ideas in this post to add modify arrays until you get to the group you need.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Adding and removing items from a list
i am hoping that myPersona is a dynamic choice field, otherwise what you are asking is would be very difficult in Ninox. some more info about what kind of fields they are and the relevant table names…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Switch with multiple for loops and consequents new records
Here is my take on it. I try to cover empty end dates and start dates that happen mid school year. Open the contratti table to see the button. I've commented the code in the button so I won't put…
Attachment
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Summary table of multiple tables
Most things are possible in Ninox. Take a look at this video about dashboards to get started and come back to the forum with fine tuning questions.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Switch with multiple for loops and consequents new records
Do you have a sample DB you can share so we can see the table structure and have some data to work with?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: List of years/months/weeks...
@Gianluca said: What I need, instead, is that each of those loops create records in the destination table. Thanks for the clarification. So my first question:…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: automatic numbering using any number column.
Here is a good post on auto numbering.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Re- in a number column, I would like to continue with auto-numbering
It hasn't disappeared. It is right here.
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 107 108 109 110 111 154

Welcome to the Ninox community

Fred

Re: How to create a field that displays all gigs worked within a range of dates?

Re: Show form of combined select (or array) logic

Re: Show form of combined select (or array) logic

Re: Show form of combined select (or array) logic

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: NEW: Dynamic print layouts for public cloud

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: How to create a field that displays all gigs worked within a range of dates?

Re: Read Data from Tables without creating manual Links

Re: Ninox Not Responding At All

Re: Problem of managing automatic record creation with trigger on the Ninox Mobile App

Re: How to create a field that displays all gigs worked within a range of dates?

Re: Constraints - Please help!

Re: How to create a field that displays all gigs worked within a range of dates?

Re: Count number of fields containing zero

Re: Count number of fields containing zero

Re: Adding and removing items from a list

Re: Adding and removing items from a list

Re: Switch with multiple for loops and consequents new records

Re: Summary table of multiple tables

Re: Switch with multiple for loops and consequents new records

Re: List of years/months/weeks...

Re: automatic numbering using any number column.

Re: Re- in a number column, I would like to continue with auto-numbering

Overview