Fred

San Francisco, USA

3699
591
5

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

My Posts

Latest Posts

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
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: Choice field: There can be only one!
One possible solution is to put this in the Trigger after update of the Status field: let t := this; if Status then for loop1 in (select child)[toTable2 = t.toTable2 and Id != t] do loop1.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Enforcing Referential Integrity
You can always change Composition to "No" then when you delete a record in the old Parent it won't delete the child.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Enforcing Referential Integrity
Ninox already does what you are wondering. You can always build a test DB and try it out.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Choice based on field content
Take a look at the substring function to find out what is in the 5th position of the text field. Do you need help with setting the choice field?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button for create a new record which has a connection to a record
I can try. You have a good start with: create TableName The issue you are encountering is you have not specified the record to link to the new record in TableName.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Ninox DB viewed in a Wordpress Website
Hi Carlos - If you want to provide interactive function (allow them to select their name and pull up specific data on just them) on your site then you will need to use a third party service like…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Formula needed:
Here is one solution: let t := this; let x := first((select AVANCES_PROYECTO)[Semana = t.Semana - 1]); 'Horas Ganadas Real' - x.'Horas Ganadas Real' It will give you a blank for the first record and…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Formula needed:
Would you like me to post a possible solution or would you like my help in figuring out a solution?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula needed:
Can you post the code that you have written so far?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Trying to get a Max numeric calculated value
Steven is correct. Ninox either 1) allow the code to go through since there is no error message or 2) shouldn't allow it and error out. bad form on Ninox's part.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Can I use a "sum" function to add up just the items found through a search?
I actually didn't answer your question. To take your formula: sum((select collections).value_av) and to then filter it you can add the following sum((select collections)['title or name' like "Rex the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Trying to copy Date and Date + Time to new Field
You can do some regex in Ninox. But it is always better to have clean data to start with.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view

1 103 104 105 106 107 148

Welcome to the Ninox community

Fred

My Posts

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

Re: Choice field: There can be only one!

Re: Enforcing Referential Integrity

Re: Enforcing Referential Integrity

Re: Choice based on field content

Re: Button for create a new record which has a connection to a record

Re: Ninox DB viewed in a Wordpress Website

Re: Formula needed:

Re: Formula needed:

Re: Formula needed:

Re: Trying to get a Max numeric calculated value

Re: Can I use a "sum" function to add up just the items found through a search?

Re: Trying to copy Date and Date + Time to new Field

Overview