Fred

San Francisco, USA

3524
550
4

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

My Posts

Latest Posts

Re: Issue about the duplicates…
That is a weird error as the table name looks correct. I can't say why you found what you found as I don't have your data to look at.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Issue about the duplicates…
You say you want a script to put the text "duplicate" in records that have a count of 1 when Ordre = myV? What happens when if you change your greater than (>) to equals (=)?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Issue about the duplicates…
Please post the code you are using.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Newbie question: Lag or delay in response to clicks/scrolling
Hi there - Well I just got forced the v3.3.2 update and now I'm seeing long responses. I only see it on a particular table that has many formulas pulling data from other tables.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
MacOS v3.3.2 long response times

Well I forgot to turn off automatic updates on my apps and now I got pushed out v3.3.2 for the MacOS and now I'm experiencing long responses on a table that has a lot of fields that reference other…
- Fred
- 4 yrs ago
- 2replies
- 247
- Get help
Re: Replace all the end of words "XX" by end "Y" ?
I'm sure you ment I wrote it in English. :) Otherwise I didn't know I was literate in French all of a sudden. It looks like all formula code has to be in English,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
No need for [] around the field name. Also check your spelling on line 3.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Sum the checked / ticked Dynamic Multiple Choice
Thanks for the update, Sean.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Sum the checked / ticked Dynamic Multiple Choice
Update, chosen does not work with Multiple Dynamic Choice fields.
- Fred
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view

1 135 136 137 138 139 140 141

Welcome to the Ninox community

Fred

My Posts

Re: Issue about the duplicates…

Re: Issue about the duplicates…

Re: Issue about the duplicates…

Re: Newbie question: Lag or delay in response to clicks/scrolling

MacOS v3.3.2 long response times

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

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

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: 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

Overview