Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3409
539
4

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

My Posts

Latest Posts

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
- 5 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
- 5 yrs ago
- 1reply
- 1036
- Get help

1 131 132 133 134 135 136 137

Back to top

Overview

View all topics