Fred's Profile | Ninox community

Badges

Latest Posts

Re: How do you know when your software (MAC) is updated?
For Ninox not to have the ability to show the version number in the app is very sloppy. The only way to know if you are running the current version is to open the App Store and see if your version…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: About = in searching words
In a text field if you do an equal then you have to match the whole field. If you switch to like "Ara" then you should find all fields with the word "Ara" in it.
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: problems with MacOS app v3.3.0
There is a new 3.3.1. Wouldn't have known from Ninox as I still haven't heard back from them. I downloaded the new version and the issues seem to be fixed. Give it a try.…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Do I need a Join Table?
There is nothing written that is very good. There is a company called Nioxus (https://nioxus.com/) that provides a basic monthly membership that provides access to their video vault that I've found…
- Fred
- 5 yrs ago
- Get help
- Reported - view
problems with MacOS app v3.3.0

Hi all - Anyone else update to the latest version for MacOS? One of my tables I can't add new records. Other tables I can add new records, but when I add or change data the new data doesn't display…
- Fred
- 5 yrs ago
- 4replies
- 434
- Get help
Re: Do I need a Join Table?
Right, then you can use a dashboard, which is a new table that has only 1 record, which you only view in form mode. You would create a link to your Clients table.…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Do I need a Join Table?
Is there a 1:N relationship between clients and assets? If so John is correct that assets should be showing up on each of the client records.
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To remove a letter at the end of words in a list
Since it only happens on some of the records, I would first take a look at the data to see if they are different? Why did ID 594 work and 285 did not? A guess is maybe they have a space at the end.…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To remove a letter at the end of words in a list
remember that all functions are lower case. look at line 3 and tell me what is wrong with it. Also your else should be Ordre not Nom, correct?
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Location of data file?
Hi Sean - In Mac OS11 there is no longer de.ninoxdb.ninox-mac.Ninox folder anymore. There is a "Ninox Database" folder. But the trail dies after /Data/Documents/data.…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Filtering subtables
Very helpful info. As with any database, more questions. 1) Is a single shipping cost really related to a single record in your inventory? Doesn't a record in your inventory have many shipping cost…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To remove a letter at the end of words in a list
If you switch substr to substring to something like: substring(Location.City.'City Name', xLen - 1, xLen) That grabs the last letter. So you can do: let xLen := length(Nom); let xSearch :…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To remove a letter at the end of words in a list
Then I guess all functions are supposed to be written in English? If so, the length is spelled wrong in your forumla. This is what I have in a test field: let xLen := length(Location.City.…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To remove a letter at the end of words in a list
can you try length instead of longueur? I don't know what functions get translated and which one don't. Do you have a link to the French manual that lists all the functions?
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To remove a letter at the end of words in a list
What do you get if you changed it to: let xLen := longueur(Nom); xLen
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Filtering subtables
Ok, just a few more questions. 1) The first screenshot is of a record in your Inventory table? Or is it a dashboard? 2) In the first screenshot is that Tarifs table a view?…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To remove a letter at the end of words in a list
Try putting a ; at the end of the first line. I'm sorry that I forgot to put that in. Any let statement needs a ; at the end.
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Filtering subtables
Hi Charlotte - It can help if we have a little better understanding of the relationships of the tables in question. What table are you in and what kind of relations (1:1 or 1:…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To remove a letter at the end of words in a list
There is the length function: length(field name). Then you can use the substr, not the substring, function to get all text minus the last one: substr(“text string”,start position,…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Create records question
Hi Sean - Looks like once you pointed me in the right direction I was able to find other solutions and some bumbling around. Here is the final code that worked. let curRec := this.…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Create records question
Hi Sean - I keep forgetting to mention the relationships. Results is N>1 to Location and Teams. Event Results is also N>1 to Location and Teams. You are correct, my terminology is incorrect.…
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: Create records question
Hi Sean - I switched it and still the Location and Team data does not get transfered.
- Fred
- 5 yrs ago
- Get help
- Reported - view
Create records question

Hi all - Here is what I'm trying to do with a button: let curRec := Id;let xLoc := curRec.Location.LocationID;let xTeam := curRec.Team.TeamID;let xCreate := (create 'Event Results');xCreate.…
- Fred
- 5 yrs ago
- 7replies
- 791
- Get help
Re: DOB > Age > Child, Adult or Senior
wouldn't Adult be if Age >= 18 and Age < 65? then Senior would be Age <= 65
- Fred
- 5 yrs ago
- Get help
- Reported - view
Re: To sort the groups…
If you are on Facebook you can join the Ninox French group:…
- Fred
- 5 yrs ago
- Get help
- Reported - view

1 152 153 154 155 156 157 158

Welcome to the Ninox community

Fred

Re: How do you know when your software (MAC) is updated?

Re: About = in searching words

Re: problems with MacOS app v3.3.0

Re: Do I need a Join Table?

problems with MacOS app v3.3.0

Re: Do I need a Join Table?

Re: Do I need a Join Table?

Re: To remove a letter at the end of words in a list

Re: To remove a letter at the end of words in a list

Re: Location of data file?

Re: Filtering subtables

Re: To remove a letter at the end of words in a list

Re: To remove a letter at the end of words in a list

Re: To remove a letter at the end of words in a list

Re: To remove a letter at the end of words in a list

Re: Filtering subtables

Re: To remove a letter at the end of words in a list

Re: Filtering subtables

Re: To remove a letter at the end of words in a list

Re: Create records question

Re: Create records question

Re: Create records question

Create records question

Re: DOB > Age > Child, Adult or Senior

Re: To sort the groups…

Overview