Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3366
532
4

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

My Posts

Latest Posts

Re: display numbers in ascending order that are in a text field ?
My mistake. That is weird. I just did it in my DB on a text field that has numbers and it shows up fine. I noticed that in your formula Nombre has a lower case N,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: display numbers in ascending order that are in a text field ?
Hi there - What you are showing me is the database sorting properly. What trips everyone up is that 1 and 10 are sorted first then 2 and 20 and 200 or 2000. They all start with 2.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To sort the groups…
Thanks for the pictures. So the data in Ordre and Espéce is text. So of course it would show you no records if you filtered on any number. You can filter Ordre by Guiformes or Apodiformes.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: display numbers in ascending order that are in a text field ?
Sorry, I used the wrong spelling. We are creating a Formule field. Name it whatever you want In the formula of the field put number("name of field").
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To sort the groups…
Can you give me an example of the data that is in Ordre? When you try to filter Ordre and you type in 2 you are saying it doesn't return any records?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: display numbers in ascending order that are in a text field ?
Sorry for not being very clear. You can delete this field and create a new formula field with the same name. The in the formula put in number("name of field").
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To sort the groups…
What kind of data is in Ordre? What you display in the picture is a count of the number of records in based on the field Ordre.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need help with a basic view
I've just come across the Order By feature myself so maybe something like: let curRec := this; let xProd := (select Product where Contacts.ContactID - curRec.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: display numbers in ascending order that are in a text field ?
conv_TextField is not a function it is just the name of the new field that you then type in number("name of field") in the formula. You can call the field whatever you want that makes sense to you.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I remove or change a table reference?
There is no unlink of a child record.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: display numbers in ascending order that are in a text field ?
If there is no text in the field you can create a new formula field called conv_TextField and have it set to number(TextField). That will convert the old text field into a number.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I remove or change a table reference?
Hi RG - If I remember right, Products is a child of Contacts. Once you link a child to the parent you can't unlink them. You can only delete the record in the child table and start over.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need help with a basic view
Hi there - Just want to verify that you want to view the lastest product purchased on the Contact you are viewing? let curRec := this; <- gathers all the data of the current record you are on select…
- Fred
- 3 yrs ago
- Get help
- Reported - view
How to best get the desired data

Hi all - I have the following tables: Riders - names of riders, country, sex Teams - team names, year active Horses - name of horses, gender, color, passport # Results - jumping results rider,…
- Fred
- 4 yrs ago
- 738
- Get help
Re: How deep can I go in a select statement
Well I figured it out: let r := this;sum((select Results where Year = "2019" and Riders.RiderID = r.Riders.RiderID).Penalty4Average_Jumped)
- Fred
- 4 yrs ago
- Get help
- Reported - view
How deep can I go in a select statement

Hi all I'm a newbie transistioning from FM and trying to wrap my head around how Ninox does things. First I have the following tables: Riders Results Teams Team Membership I'm working in Team…
- Fred
- 4 yrs ago
- 1reply
- 1036
- Get help

1 129 130 131 132 133 134 135

Back to top

Overview

View all topics