Fred

San Francisco, USA

3746
594
5

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

My Posts

Latest Posts

Re: Calculate Period Progress.
Please post your code or a sample DB.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
Another question is what are you trying to accomplish? Is a user supposed to type in Liste? If the user is supposed to type then it seems like an extra step when they can just select the correct…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
What kind of field is Liste?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Analysis of your database structure with Ninext
Ok, well here is my results with code analysis: "nbTables": 35, "nbFields": 0, "fieldByType": { "Text": 46, "Number": 112, "Formula": 906, "relation <= 1:N (Test)": 53, "Yes / No": 28, "relation => N:…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: GPT for Ninox
@Jacques TUR Of course you are in a train.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: GPT for Ninox
Sorry to be the dumb American, but how do/can you switch the language to English?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
@Jacques TUR said: I have just added a function to Ninext to return the analysis: #{return ninext.schemaAnalysis(true)}# Where do you put this code? In the Ninext.start? ninext.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Loop through Records
Hi@stephenjtaft I just noticed that I haven't responded to your last post. I'm sorry about that. Do you still need help with this?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Analysis of your database structure with Ninext
Here are my results: { "nbTables": 35, "nbFields": 1251, "fieldByType": { "Formula": 906, "Number": 112, "relation <= 1:N": 52, "relation => N:1": 52, "Text": 46, "Yes / No": 28, "Choice": 19,…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Formula for button to copy table
I tested it on your DB you sent me and I saved it to my local HD in the App and the date changed. I started with the Apr 16th record and then clicked the button and a new record was created with the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Issue/Bug in report creation
@Alan Cooke I hate to break it to you but Ninox's solution is their dynamic printing. Which is not available to local DB users. They will most likely not spend any effort fixing their old print…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Whether the data content of table1 field can become the field of select(table2)
@張良仲 With how you setup your DB, it is not simple. Did you try@John Halls DB? Did you modify your DB to use a N:N table? Your code should work as long as A, B, C,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formula for button to copy table
I tested in the app with a cloud and local DB and was not able to reproduce it. Can you upload a sample DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: New Member Introduction - Seeking Guidance and Tips
You don't mention if you have previous relational DB experience. If you come from the spreadsheet world, I would say that understanding and getting comfortable with relationships is very important.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: New Member Introduction - Seeking Guidance and Tips
Welcome Mitchel. You can get help here in the forums. There is an official Ninox FB page, but support is provided by other users. If you have a Pro account with Ninox you can email them.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Need Script for transfer Dates
@Rafael remember you are now inside a for loop, so your me variable (which is linked to this) will link all of your record to this one record. You need to change your references from me to s.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Active processes in background
Sadly a starter can’t. You can email Support. They usually help with big stuff like this.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need Script for transfer Dates
I did a test and found this works: newR.( 'Control Deliverables_>' := me; Name_Document := me.'Name Document'; 'Forecast 1' := me.'Real 1'; 'Real 1' := me.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Loop through Records
@stephenjtaft said: just to have the large freedom to add multiple granular permissions I guess we are thinking differently about what a permission is. My thinking was in terms of permissions to do…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to add to variables
@mark. robinson It is not that Ninox is not returning a number. It is, but if you don't use one of the array commands, then Ninox will return an array of numbers.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Loop through Records
to answer your question, I first need to tell you how multiple choice (regular or dynamic) fields work. Once you select a second choice, then Ninox will return an array of the choices.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: createXLSX: format column as currency
@Andy I just looked at video 130 and you only talk about making column G right justified. You don't mention anything about setting it to Currenty or Date with in createXLSX().
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: an you please help me optimize the code structure?
@我是我的我 It seems like all your cases are exclusive, but remember to put the case that will happen the least often at the top and the cases that happen the most often at the bottom.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: an you please help me optimize the code structure?
@我是我的我 with such a complicated set of ifs and switches you will need to start at the beginning and with a new formula field start with your first if then slowly add the switches and ifs one step at a…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Query Help - Count of records in joined table that meet X criteria
you can try: count('Staffing Gigs'[year('event date') = year(today())]) When you are filtering relationship fields you use the square brackets [ ]. You can also use the year() command to get the year…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view

1 40 41 42 43 44 150

Welcome to the Ninox community

Fred

My Posts

Re: Calculate Period Progress.

Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected

Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected

Re: Analysis of your database structure with Ninext

Re: GPT for Ninox

Re: GPT for Ninox

Re: Analysis of your database structure with Ninext

Re: Loop through Records

Re: Analysis of your database structure with Ninext

Re: Formula for button to copy table

Re: Issue/Bug in report creation

Re: Whether the data content of table1 field can become the field of select(table2)

Re: Formula for button to copy table

Re: New Member Introduction - Seeking Guidance and Tips

Re: New Member Introduction - Seeking Guidance and Tips

Re: Need Script for transfer Dates

Re: Active processes in background

Re: Need Script for transfer Dates

Re: Loop through Records

Re: how to add to variables

Re: Loop through Records

Re: createXLSX: format column as currency

Re: an you please help me optimize the code structure?

Re: an you please help me optimize the code structure?

Re: Query Help - Count of records in joined table that meet X criteria

Overview