Fred

San Francisco, USA

3380
533
4

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

My Posts

Latest Posts

Re: (JSON) Object parser Browser vs. Client
@Christoph Did you email Ninox to let them know? Maybe they will fix it. We will just never know until you try it again in a future version. While the app seems to be 99% functionally identical,…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Populate a choice list with values based on a selected value from lookup
@Vermaji glad to hear it is working out. when you have a moment can you mark the post "answered" so others can know if the post could be helpful for them.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
Try these two things: 1) put the date/time fields inside date() commands. So 'Fitting Date/Time' would be date('Fitting Date/Time). I don't know if 2nd Fit Date is also a date/time field,…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Populate a choice list with values based on a selected value from lookup
On to part b, for 'Contact Phone' you can use the following: let contactRec := record('Client Contacts',number(dC)); contactRec.Phone dC is a new dynamic choice field from the previous post.…
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Populate a choice list with values based on a selected value from lookup
In Ninox you would use a dynamic choice field to create what is known as 'lookup' in other DBs. So you can delete the current choice field called Contact Name and create a new dynamic choice field…
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Storing array in a table column
Have you looked at Ninox’s Invoice template for some ideas?
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Storing array in a table column
@Vermaji Thankfully Ninox did away with obvious keys. We don’t have to setup fields that we call a key to link records. We just create reference fields and Ninox handles the linkage.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Storing array in a table column
@Vermaji Ninox uses tables and corresponding records as the base for their dynamic fields. Since your color field is a multi choice field then you can’t make a dynamic field from a multi choice field.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Storing array in a table column
Some thoughts: In your invoice item table you may want to make all fields either text or number fields, or fields that are not linked to other records. You would copy the appropriate data over.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Storing array in a table column
Welcome to Ninox. Since you used the word 'array' in your question, I am guessing you have some DB/coding background. You are correct, Ninox handles multi choice fields in arrays if you use the…
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Time to create more work for myself...
Here is an example of how the new subtable makes coding easier. I have a field that looked like this before the new subtable: let t := this; switch League do case 1: switch 'Round Type' do case 1:…
- Fred
- 7 mths ago
- 3
- Learn and Share
- Reported - view
Re: Time to create more work for myself...
A small redesign like this would not have been possible without@Jacques Ninext project. I can see if a field is being used in other formulas (red) or views (green) before I delete them.…
- Fred
- 7 mths ago
- 1
- Learn and Share
- Reported - view
Re: Time to create more work for myself...
@John Halls Thanks. I track team show jumping. The three leagues are Global Champions League, Major League Show Jumping, and League of Nations.
- Fred
- 7 mths ago
- Learn and Share
- Reported - view
Re: Time to create more work for myself...
@John Schaffer Thanks. Learning everyday.
- Fred
- 7 mths ago
- Learn and Share
- Reported - view
Time to create more work for myself...

Never to leave a functional DB alone, I decide to correct some poor DB design. As you can see in the picture, I break the tenant of not creating multiple fields that store the same type of data.…
- Fred
- 7 mths ago
- 7replies
- 125
- 1
- Learn and Share
Re: Does Email with Starter Cloud allow it to come from my email/domain?
I don't think so. If you look at the pricing page it says: Custom SMTP server is at the enterprise level. Which makes sense since they don't even provide email support at the starter level.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
@我是我的我 You can use alert() since you only want one pop up to appear. Just be aware that if they make any changes you could see many. I’ll post a possible change to the code later so only 1 pop up…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
@我是我的我 Ninox says to use dialog() instead of alert(). Ninox shows each alert but does not pause in between loops, so the alerts are stacked. I guess dialog() does pause properly.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@Alain Fontaine said: According to the definition of the "slice" function, "slice(array,0,0)" produces a slice that starts with the first element, and ends BEFORE the first element,…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@John Halls This was my first attempt at using the while function. The while scares me.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
So happy to see all of the different ways any solution can be done. You guys are the best.
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Populate a field with values from a list
Thanks to@Alain Fontaine here is another script to have non-repeating values. let letterArray := ["A", "B", "C", "D", "E", "F", "G", "H", "I", "J"]; let numArray := slice([0], 0, 0);…
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@Alain Fontaine Awesome! That works great. Would've never thought to use the slice() command. It still reads to me that there should be a leading zero since you are asking for the first item and zero…
- Fred
- 7 mths ago
- Get help
- Reported - view
Help with code to create non-repeating set of 10 numbers

So I'm working on trying to create a non-repeating set to 10 randomly selected numbers between 0 and 9. I have this in a formula field: let x := [number(void)]; while length(x) < 10 do let newItem :…
- Fred
- updated 7 mths ago
- 12replies
- 78
- Get help
- Answered
- Answered
Re: Populate a field with values from a list
This was an interesting ask. Here is my 2 cents on the matter. Put the following in a button and have a text field called Text on the same form. let letterArray := ["A", "B", "C", "D", "E", "F", "G",…
- Fred
- 7 mths ago
- Get help
- Reported - view

1 22 23 24 25 26 136

Welcome to the Ninox community

Fred

My Posts

Re: (JSON) Object parser Browser vs. Client

Re: Populate a choice list with values based on a selected value from lookup

Re: Formulate View field from multiple date entries?

Re: Populate a choice list with values based on a selected value from lookup

Re: Populate a choice list with values based on a selected value from lookup

Re: Storing array in a table column

Re: Storing array in a table column

Re: Storing array in a table column

Re: Storing array in a table column

Re: Storing array in a table column

Re: Time to create more work for myself...

Re: Time to create more work for myself...

Re: Time to create more work for myself...

Re: Time to create more work for myself...

Re: Does Email with Starter Cloud allow it to come from my email/domain?

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: Help with code to create non-repeating set of 10 numbers

Re: Help with code to create non-repeating set of 10 numbers

Re: Help with code to create non-repeating set of 10 numbers

Re: Populate a field with values from a list

Re: Help with code to create non-repeating set of 10 numbers

Help with code to create non-repeating set of 10 numbers

Re: Populate a field with values from a list

Overview