Fred

San Francisco, USA

3373
533
4

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

My Posts

Latest Posts

Re: A formula to really change numbers in text in a column in a real numbers columns ?
From you picture it looks like you selected Count not Sum. You see the # next to 1110. That is the count symbol. ∑ is the sum symbol. Are you try trying to convert the "Nb especes" field to a number…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Is there a syntax for 'select distinct'?
You can use the unique function: unique(field name) unique(variable) let x := select Invoices count(unique(x.CustomerID))
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-enter appointment dates
Take a look at this: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/filling-an-appointment-field-5c913ec0837ecb36673fc031 You can create a button to launch a one time loop that…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula randomly displays date+hour instead of only date
I just tried that and was able to duplicate it. Weird as I only picked days. Anyways, if you just want to find the number of days between two days you can use the days function: days(start,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Concatenate for sum
sorry, i didn't see the picture.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Concatenate for sum
what is a filer box? You can only use sum, average, min, max on arrays so you need to first take our list of numbers then you can concatenate them then you need to split them into an array.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Home page for users
Welcome to Ninox and their horribly written manual. They are on v3.3.x for the cloud and MacOS app. I have no knowledge of the server edition but I'm guessing it is in line with the cloud version.…
- Fred
- 3 yrs ago
- Learn and Share
- Reported - view
Re: Home page for users
Hi there - There is the opentable function, scroll down to User Interface Automation https://ninox.com/en/manual/calculations/reference-of-functions-and-language I can see where you create a table…
- Fred
- 3 yrs ago
- Learn and Share
- Reported - view
Re: Bug report
Something similar happened to me. On the app I have many forumal fields that rounds a division calculation to 3 spots then multiply by 100 and they shows up fine.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bug or Limitation: Combo Box References: Limited Capacity
First of all, wow! 500 enteries in a combo box is huge. Is there any way of categorizing them so you can do a cascading selection. You would select Category 1, then Category 2, then actual item?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Changing field format
sadly there isn't an easy way to convert field types. you will have to create a new field then create a button that will copy the data from the old text field to the new choice field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
You wrote: let xStatus := ((select Timesheet where VolunteerID = curRec and curRec.Status = 1) order by WorkDay).WorkDay;if xStatus = today() thenalert("You have already checked in!…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Hello ! I dont understand how to use the new "Dynamic choice (or multiple) fields ! How can I determine values to be displayed in this hind of field ?
Can you provide a bit of background on your db? What are your tables? What fields are you trying to display? etc. Thanks.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Hello ! I dont understand how to use the new "Dynamic choice (or multiple) fields ! How can I determine values to be displayed in this hind of field ?
In Dynamic value name. Enter in the field names you want to use. For example I have a Dynamic Multiple Choice field called Riders. The Dynamic Value is set to select Riders <--my Riders table.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
Here is my code: let curRec := this;let t := last((select Timesheet where Volunteer = curRec) order by WorkDay);if t.WorkDay = today() then t.(ClockOut := datetime(now())); t.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view

1 129 130 131 132 133 134 135

Welcome to the Ninox community

Fred

My Posts

Re: A formula to really change numbers in text in a column in a real numbers columns ?

Re: Is there a syntax for 'select distinct'?

Re: Auto-enter appointment dates

Re: Formula randomly displays date+hour instead of only date

Re: Concatenate for sum

Re: Concatenate for sum

Re: Home page for users

Re: Home page for users

Re: Bug report

Re: Bug or Limitation: Combo Box References: Limited Capacity

Re: Changing field format

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

Re: Hello ! I dont understand how to use the new "Dynamic choice (or multiple) fields ! How can I determine values to be displayed in this hind of field ?

Re: Hello ! I dont understand how to use the new "Dynamic choice (or multiple) fields ! How can I determine values to be displayed in this hind of field ?

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

Overview