Fred

San Francisco, USA

3366
532
4

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

My Posts

Latest Posts

Re: Sum the checked / ticked Dynamic Multiple Choice
Update, chosen does not work with Multiple Dynamic Choice fields.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sum the checked / ticked Dynamic Multiple Choice
Hi Mel - Give it a try with a Multiple Dynamic Choice field. If you do a count you only get 1. As you can see in my example, Riders is a multiple dynamic choice field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sum the checked / ticked Dynamic Multiple Choice
I asked that question to Nixous and they said it should and will bring it up to Ninox. I'm not sure when or if I'll hear back.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
One way is: 1) first check if "Ara " (space included) is at the beginning. So we would use the substring function to pull out the first 4 characters: let xBegin := substring([field name],0,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Just to be clear, do you only want fields that start with the word Ara and have other words after it. You want to ignore words that only have Ara in the field?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
If you only want "Ara" then you would do =.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Remember that putting a period at the end of a function tells Ninox to look for a record. Please make sure you check puncuations, especially when you copy and pasting from the website.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
You copied too much of my sentence. You only need one replace function. You need to remove one of them, which one do you think you should remove?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Is this more error correction or is this a functional need? If it is error correction then just do what you did for the misspellings. If it is functional, then the replace function.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I format this field?
Since there is no error message, the field name is valid. I'm stumped. Maybe someone else has experienced something similar.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I format this field?
That is confusing. Like I said earlier, it looks like a typical formula window, but if you just add the name of the field you want to show then it will just show that field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Expiration date in colour
Hi MP - go back a page and see Steven's response. Your use of (date field - today) gives you a number counted in miliseconds since Jan 1, 1970. if you use the days(start,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
you have to do a select all before you do a "massive modification of datas". after you typed in "Accepiterus" and clicked Next did it show any records being modified or was the screen blank?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I format this field?
I've never tried putting a formula in a Show As. I just use the field names that I want to show. I can do a concat of field names.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to associate multiple records in one table with a record in another table
In TableB, find the Id of the record you want to link to. If need be show the column. Don't use any personal ID number you may have created. You have to use the Ninox Id for the record Return to…
- Fred
- 3 yrs ago
- Get help
- Accepted
- Reported - view
Re: To replace a letter or a number at the end of a word
ok, to clarify step 2. 2) for iPad user, in table view, click on the rectangle icon with two lines that is next to the Search box then click on Select All
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
if this is just a data correction job then: 1) filter for Elephand 2) right click on a number in the table and click on Select All 3) click on the Gear icon and select update multiple records 4)…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
Are you going to be replacing the last letter or number with a static letter or number, i.e. everything will end with "X". or will it vary depending on what it finds?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get newly created fields to appear in an existing form? I added fields after the initial setup of a database but I don't see those newly created fields in the form.
Click on any of the column names, then click on Show Columns, then select the field you want to show.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Love the ability to reference a code block in formulas
thanks, I'll give it a look.
- Fred
- 3 yrs ago
- Learn and Share
- Reported - view
Re: How do I format this field?
When you click on Show As it will take you to the Formula editing window. From there you can just select the field name you want to show, i.e. Customer.Name.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Love the ability to reference a code block in formulas

I have a sport league db, so there are lots of stats that use the same block of code. I would love the ability to reference the block of code once so I can make changes to once and it will update…
- Fred
- 3 yrs ago
- 2replies
- 390
- Learn and Share
Re: Price books and ninox
So let us say you have the following tables: Customer Article Pricebook reference field to Customer and Article Sales Order reference field to Article and Customer You want to create a new Sales…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Price books and ninox
if you have the following number fields: price discount <-- data is stored as decimal, so you would type .1 instead of 10 then a formula field called 'final price', or whatever you want to call it,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Populating a field in one table with text value from another table
Hi Stephen - Your thinking would working if there is a relationship between T1 and T2. If there is no reference field in either table linking the two then you just can't say: if T1.Name = T2.…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 129 130 131 132 133 134 135

Welcome to the Ninox community

Fred

My Posts

Re: Sum the checked / ticked Dynamic Multiple Choice

Re: Sum the checked / ticked Dynamic Multiple Choice

Re: Sum the checked / ticked Dynamic Multiple Choice

Re: Replace all the end of words "XX" by end "Y" ?

Re: Replace all the end of words "XX" by end "Y" ?

Re: Replace all the end of words "XX" by end "Y" ?

Re: Replace all the end of words "XX" by end "Y" ?

Re: Replace all the end of words "XX" by end "Y" ?

Re: Replace all the end of words "XX" by end "Y" ?

Re: How do I format this field?

Re: How do I format this field?

Re: Expiration date in colour

Re: To replace a letter or a number at the end of a word

Re: How do I format this field?

Re: How to associate multiple records in one table with a record in another table

Re: To replace a letter or a number at the end of a word

Re: To replace a letter or a number at the end of a word

Re: To replace a letter or a number at the end of a word

Re: How do I get newly created fields to appear in an existing form? I added fields after the initial setup of a database but I don't see those newly created fields in the form.

Re: Love the ability to reference a code block in formulas

Re: How do I format this field?

Re: Price books and ninox

Re: Price books and ninox

Re: Populating a field in one table with text value from another table

Overview