Fred

San Francisco, USA

3701
591
5

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

My Posts

Latest Posts

Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
@Walcher Messebau What does the data in Keywords look like?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Calculate Period Progress.
@Rafael can you write the code to create 1 record and create the proper percentages?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
You can try the following in a button to test it out: let getAllegatiRec := (select Allegati where Aktiv = 1); let makeArray := split(Liste, ", "); let getSelectedAllegatiRecs :…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Calculate Period Progress.
@Rafael So what fields are used in the math to figure out percentage?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Calculate Period Progress.
@Rafael said: Progress-Cost Report is genereted by a script. Now need the formula to calculate the period progress. So where is this script?
- Fred
- 1 yr ago
- Get help
- Reported - view
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

1 38 39 40 41 42 149

Welcome to the Ninox community

Fred

My Posts

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

Re: Calculate Period Progress.

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

Re: Calculate Period Progress.

Re: Calculate Period Progress.

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

Overview