Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Parent - Child Record Update Example. Code Help to Complete Needed.
If you really want the alerts then they can NOT be in Triggers. They have to be in buttons cause they have to be run client side. Triggers run on the server side.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
let a := last((select Timesheet where volunteer = this order by 'Work Date'); <-- too many open parenths, just get rid of one of them
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
Code block 2: You should be using the variable a in your field references instead of Timesheet. I think that is the issue as you are telling it to use the whole table Timesheet and not the single…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
In Code Block 1: let v := this;let a := last(select Timesheet where Volunteer = v order by 'Work Date').'Work Date'; <--Since Volunteer is a reference field you only need to set it to your this…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: table view with both combo box (selected options and 'empty or null option) in same view
One option if you want to stay in the same table, is to create another field and then sort by that field. Create a formula field called SortStatus and set it to number(raw(Status)).…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How to Parse Text Into Multiple Form Fields on Button Click
You might not need a button if each record has the base text string that you want to parse. Let say you have a field called origText. Then you would need to create an array out of it with split…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: date - year - select - vista
You can add this line to your VISITE formula to get the data from your current record: let curRec := this; Then add this to your select statement: select VISITE where PROFILASSI and PAZIENTI.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Issue about the duplicates…
If you have the online version you can add me as a user. Now how to pass along my email address without putting it on this site. If you on FaceBook, did you happen to join one of the Ninox groups?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Where is the error ?
Do you have a field Couleur in the table Couleur? That is what Line 4 says. In another way you wrote: let mySup := first(select Couleur where Couleur = myrec)
- Fred
- 4 yrs ago
- Get help
- Reported - view
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

1 147 148 149 150 151 152 153

Welcome to the Ninox community

Fred

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: table view with both combo box (selected options and 'empty or null option) in same view

Re: How to Parse Text Into Multiple Form Fields on Button Click

Re: date - year - select - vista

Re: Issue about the duplicates…

Re: Where is the error ?

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

Overview