Fred's Profile | Ninox Community

Badges

Latest Posts

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
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
- 3 yrs ago
- Get help
- Reported - view
Re: Impossible to add a new recording…
I've done it. And not just once. 😂
- Fred
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Jacques TUR Whatever you did made a huge difference. Now it is useable on my main DB. Thanks for continuing to work on this.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Loop not clear
Yeah the manual is not very good. You can try something like: let loop1 in select contacts[firstnames = null] do loop1.firstnames := "Norbert" end or if you have your select in a variable already you…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Where is Working Phase Lookup????
I've always use a variable when using the create command. I think it helps Ninox keep track of the new record better. I've seen people not use in other formulas,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Reference to items in the same table
Take a look at this post. It even has a sample DB you can see what is going on.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Reference to items in the same table
Just a reminder that dynamic choice fields have a 100 item limit.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Latest update broke Ninox!??
@james said: On the Mac App Store, Ninox is now at 3.7.6. Has anyone updated to this version? Is it still buggy? So far so good for me. They fixed Jason's issue and sorta of fixed mine.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Where is Working Phase Lookup????
@Mauro Schiappelli said: In the new created record the Field WorkingPhase is null. But newWorkPhase contains value!!! That was my first question. If you put: let currentRow := this; let newPhase:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Newbie Formula Question
Welcome to the world of DB. What is the reference field name that links your two tables together? Can you post a picture of your data model?
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Time calculation problem after the update
if you create two more formula fields and put: number(Time1) in one and number(Time4) in another you will see that they are not the same time. Time1 is exactly 3,600,000 and Time4 is 3,646,313.…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 107 108 109 110 111 153

Welcome to the Ninox community

Fred

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

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

Re: Loop not clear

Re: Where is Working Phase Lookup????

Re: Reference to items in the same table

Re: Reference to items in the same table

Re: Latest update broke Ninox!??

Re: Where is Working Phase Lookup????

Re: Newbie Formula Question

Re: Time calculation problem after the update

Overview