Fred's Profile | Ninox Community

Badges

Latest Posts

Re: How do make a record creation step precompile a table with "Link from?"
Sounds like you have two questions. We will start with just the first one. When I insert a new replacement part I would like the machine already inserted in the intervention on the replacement parts…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to show all fields at once?
For display purposes, I would say that having over 100 fields in one view would make the view unwieldy to use effectively. I would create different views showing different fields.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula with calculation between two different times
Try these changes: if time() > time(9,59) and time() < time(10,59) then "Yes, the hour is in between 10 and 11" else "No" end Check out this post in the Ninox docs for tips on the time function.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Filter an array based on a Multichoice using another Multichoice
Thanks, Jacques. It is nice to know I was on the right track. I wasn't sure if I could do the count in another count.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Filter an array based on a Multichoice using another Multichoice

So I was wondering how to filter an array that will keep NId and then compare a basic multichoice with another basic multichoice. If you open the attached DB,…
- Fred
- 3 yrs ago
- 3replies
- 212
- Get help
- Answered
- Answered
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

1 106 107 108 109 110 153

Welcome to the Ninox community

Fred

Re: How do make a record creation step precompile a table with "Link from?"

Re: How to show all fields at once?

Re: Formula with calculation between two different times

Re: Filter an array based on a Multichoice using another Multichoice

Filter an array based on a Multichoice using another Multichoice

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

Overview