Fred

San Francisco, USA

3608
568
5

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

My Posts

Latest Posts

Re: If condition not working with comparison operators
Well I got this to work for me: let currentDate := today(); let invoiceDueDate := 'Due Date'; let currentInvoiceStatus := number('Invoice Status'); let overdueDays := days(invoiceDueDate,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Way to Assign multiples fields to another table.
@Rafael that is a good start. Try this: let x := for loop1 in numbers('Category & Rate') do record('Hours by Resources',loop1).'Rate bt Categ' end; sum(x)
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Way to Assign multiples fields to another table.
@Rafael if you need a hint on how to get started, try setting a variable using the record() command inside a for loop with the numbers() command around the dynamic multi choice field.…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Learn and share
- Reported - view
Re: Time to create more work for myself...
@John Schaffer Thanks. Learning everyday.
- Fred
- 1 yr 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
- 1 yr ago
- 7replies
- 133
- 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 1
- Get help
- Reported - view

1 31 32 33 34 35 145

Welcome to the Ninox community

Fred

My Posts

Re: If condition not working with comparison operators

Re: Way to Assign multiples fields to another table.

Re: Way to Assign multiples fields to another table.

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

Overview