Fred

San Francisco, USA

3420
539
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Problem of managing automatic record creation with trigger on the Ninox Mobile App
can u upload a sample of your DB?
- Fred
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: automatic numbering using any number column.
Here is a good post on auto numbering.
- Fred
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: List of years/months/weeks...
@Gianluca said: Let's say that I need to write: "blue" when the range of the loop is (0,1) "red" when the range of the loop is (1,2) "yellow" when the range of the loop is (2,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Impossible to add a new recording…
I've done it. And not just once.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Dates Overwritten with Epoch Date on Opening
@Jared W. said: In the meantime, I was also able to work around the issue by clearing the date and duplicating the records. I was thinking that you could create another formula field that checks for…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button to validate required fields
You would have to write the script yourself. I am unsure what you want to happen. If field Text1 is empty and you click the button what do you want to happen?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
I've just tried the search and it works perfectly. This is going to be a game changer!
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Problems with Formula Don't give me anything.
Now how can I do That ? If possible with Choice (dynamic) If the table that you link to has the date data you need then yes that would be better.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Problems with Formula Don't give me anything.
I have a Choice field With DateR1, DateR2...... to R5 If the choice field selections are what your wrote "DateR1" etc. Then that is not a date field.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: List of years/months/weeks...
With something this large and complicated, I would first figure out which case is not working (0 or 1). Then break down each step in another formula to make sure each step works.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Dates Overwritten with Epoch Date on Opening
That is weird. So I'm using the MacOS app v3.7.6, and I am able to reproduce the error, but only on DBs that do NOT have the Time Zone Independence feature enabled.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
Wow, I’ve always wanted to be able to search my Edit Fields list. You are the best!
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Loop not clear
oops, it should be: for loop1 in select contacts[firstnames = null] do loop1.firstnames := "Norbert" end typing too quick for my brain to follow. it is a for loop so I need to put a for in the…
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 91 92 93 94 95 137

Welcome to the Ninox community

Fred

My Posts

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

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

Re: Impossible to add a new recording…

Re: Dates Overwritten with Epoch Date on Opening

Re: Button to validate required fields

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

Re: Problems with Formula Don't give me anything.

Re: Problems with Formula Don't give me anything.

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

Re: Dates Overwritten with Epoch Date on Opening

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

Re: Loop not clear

Overview