Fred

San Francisco, USA

3366
532
4

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

My Posts

Latest Posts

Re: Counting the number of
Hi John - I like your solution as well. If you have hundreds of thousands of records this approach is a very fast way to get sums/counts/etc. I'm not sure I understand your question around the where…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Counting the number of
Are you trying to create a filter or a field? I don't think filters can do select statements or pull data from another table. One way, is create a new formula field in your JOBS table or a new…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Invitations
Hi Michel - You can also create another Team then put that one database in that Team and invite the user to that Team. Probably a lot faster if you have lots of databases.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy record data from a table and create a record in other table
Also, since SUB - USERS is a reference field, you only need to do: x.('SUB - USERS' := curRec.'SUB - USERS') Then this will create the proper link in the ORDERS table.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy record data from a table and create a record in other table
If you delete 'ID PROD', then start typing id what fields does it offer you? if it offers you ID PROD does it work then?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: MacOS v3.3.2 long response times
Thanks for responding Maria. I have an open ticket with Fabian, and he as passed it along to developemnt. I hope they get it fixed soon. I've updated to 3.3.4 and the problem is even worse.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Invitations
Hi Michel - First did you put the user in a different group than admin? If so then: Open your other databases click on the wrench icon click on Security change the Open Database to a group that the…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy record data from a table and create a record in other table
Hi there - Maybe this will work: 1) you need to create a variable to your current record: let curRec := this; 2) then you can simplify the next section to: let x := (create 'ORDERS B'); x.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Distributing a database
Hi Michel - One way would be to download an archive of the database with no data or files and send that to your customers to upload to their own account.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Activate / Local or cloud database
Hi Michel - The online version is always accessed through a browser and thus available through any device with a browser. As the product page shows, there is no Windows app.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Hi, How do I check if the current Year has changed?( I want to reset a counter on the first record of the new year)
Maybe this is something that will work for you. I have this basic formula in a button: let LDate := last(((select Projects) order by 'Created on').'Created on');…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Progressive sum
'this' tells Ninox to get the data of the current record you are on. you can then use any field from that record like Steven did in the second line: d.'Month n°'.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Update a file names
If this is a one time task, then you can find the missing names, export to a csv, then import the csv to the other db. If it is a on going task keeping the two dbs in sync,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Extract names from compound names
I'm unsure what you want to do? Your current code is looking for "Ara". What do you want it to look for now?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Create a routine/loop
How about something like this: for loop1 in select Table1 where 'field A' = 0 do loop1.('field A' := 1)end If this is a one time data correction then doing a Update Multiple Records would be a faster…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Question about the numbers and names of column
I see that these are just text fields. I guess in French the default name is Column. In English it is just Text. If I keep adding Text fields and not change the name they get numbered.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Question about the numbers and names of column
Can you give an example of where your columns show up as Column1, Column2, etc. I'm using the web version and I can't seem to figure out how to add a column that does what you describe.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: A formula to really change numbers in text in a column in a real numbers columns ?
This is my example. When the numbers are aligned on the left side they are being treated as text. When numbers are aligned on the right side they are being treated as numbers.
- Fred
- 3 yrs ago
- Get help
- Reported - view
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

1 129 130 131 132 133 134 135

Welcome to the Ninox community

Fred

My Posts

Re: Counting the number of

Re: Counting the number of

Re: Invitations

Re: Copy record data from a table and create a record in other table

Re: Copy record data from a table and create a record in other table

Re: MacOS v3.3.2 long response times

Re: Invitations

Re: Copy record data from a table and create a record in other table

Re: Distributing a database

Re: Activate / Local or cloud database

Re: Hi, How do I check if the current Year has changed?( I want to reset a counter on the first record of the new year)

Re: Progressive sum

Re: Update a file names

Re: Extract names from compound names

Re: Create a routine/loop

Re: Question about the numbers and names of column

Re: Question about the numbers and names of column

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

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

Overview