Addinsell

Joined: Tue Jun 30 08:38:45 UTC 2020

My Posts

Latest Posts

Re: Replace all the end of words "XX" by end "Y" ?
You are right : I used a translator…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Yes, you wrote it in French, I translated : I replace "si" by "if" and "alors" by "then". And that works. Thanks a lot again.
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Thanks Fred. So I key in : let xBegin := substring([Nom],0,4) let xLen := length([Nom]) si xBegin = "Ara " alors substring([Nom],4,xLen) end I get this : "The function is not defined :…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Yes, Fred. (I thought about "includes" or "contains" but I can't make them work…)
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Sorry…I made a mistake : that works well, thanks What if I would like to get only Ara with another word next to it, like : "Ara bleu", "Ara rouge", "Ara vert"… ?
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Thanks Fred. I tried =Ara ="Ara" I got all the Ara and even all the Araçari and Araponga !
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Thanks a lot Fred, I'll try to remember it ! It works well. About the same kind of idea, maybe you could help me. About the conditional styling. Among a list of perrots I have :…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
I tried : replace(Famille, "ae", "é"). I got : "Expression does not return a record :replace(Famille,"ae","é") on the line 1 column 28"
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Replace all the end of words "XX" by end "Y" ?
Thank you Fred. It is functionnal. The name of my column is "Famille" So I create a field formula in wich I typed : replace(Famille, "what to look for", "what to replace with").…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Replace all the end of words "XX" by end "Y" ?

Hi Could someone tell me how could I replace all the end of words "ae" by end "é" ? Ex Ciconidae > ciconidé Aramidae> Aramidé Columbidae > Columbidé Falconidae> Falconidé Thanks
- Addinsell
- 3 yrs ago
- 17replies
- 861
- Get help
Re: To replace a letter or a number at the end of a word
Hi Fred, it works well I made a mistake… Thanks again.
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
In fact that has created a formula field plenty of "Accipiterus" !!
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
-I did it ! -Yes it was written in blue Accipiterus
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
Ok thanks Fred I did what you said but it does not work I filter "Accipiter" in my colum "Nom" I go to the gear icon I select "massives modifications of datas" Down,…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
Thanks Fred, "2) right click on a number in the table and click on Select All" Is there another way ? I am with an Ipad and there is a bug that prevents me to to select a column (I contacted the…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
Hi Fred, I have 230 Elephand And I'd like to change for 230 Elephant I have 32 numbers 127 And I'd like to change for 32 numbers 128
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
To replace a letter or a number at the end of a word

Hi, Can someone tell me how to replace a letter or a number at the end of a word in a list ? Ex 127 > 128 Elephand > Elephant Thank you
- Addinsell
- 3 yrs ago
- 10replies
- 674
- Get help
Search an exact word in a field with a formula

Hi I'd like to search an exact word in a field with a formula with the visual tab. Can someone tell me the way to do it ? Thank you
- Addinsell
- 3 yrs ago
- 261
- Get help
Re: Undo the action of a button with another button
No Mel, I created a button to display the duplicates and the no duplicatres in a column and after I removed the dupicates
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Impossible duplicate a base
Thank you Mel, there is a litte square but it is imp0ssible to check it !
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Impossible duplicate a base
Sorry, I have a "message" not a "question"…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Impossible duplicate a base
In fact I have a question "select fields to copy" but when I touch a field nothing happens, impossible to select !!
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Can one delete the action created by a button activating a function?
The script works. I create a new button with it but how do you put that in the button involved ? Do I have to put it the script of the button? If yes, at wich place in the script ? Here is my script :…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Can one delete the action created by a button activating a function?
Scusate, ho tradotto lo script in francese, quindi la mia domanda non ha senso...
- Addinsell
- 3 yrs ago
- Get help
- Reported - view
Re: Can one delete the action created by a button activating a function?
Ciao Antonello Grazie mille per la tua risposta.Alcune domande: -Non ho questo popup di avviso quando clicco sul pulsante... -Nel tuo script ci sono parole in inglese e parole in francese...…
- Addinsell
- 3 yrs ago
- Get help
- Reported - view

1 6 7 8 9 10 17

Welcome to the Ninox community

Addinsell

My Posts

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

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

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

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

Search an exact word in a field with a formula

Re: Undo the action of a button with another button

Re: Impossible duplicate a base

Re: Impossible duplicate a base

Re: Impossible duplicate a base

Re: Can one delete the action created by a button activating a function?

Re: Can one delete the action created by a button activating a function?

Re: Can one delete the action created by a button activating a function?

Overview