Fred

San Francisco, USA

3381
533
4

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

My Posts

Latest Posts

Re: Is there another way to display the filtered data?
What you are showing is the grouping function of the column. There is no way to tell Ninox to order the group number in the table view. I would recommend that you use a dashboard and view elements or…
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Richard v. L. I just tried it and it worked fine on my mac.
- Fred
- 8 mths ago
- Learn and share
- Reported - view
Re: Calculate Period Progress.
@Rafael Are you trying to do a running total? Haven't we done this before?
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
@Walcher Messebau here is the db. I tried it both cloud and local/icloud and they both function the same. If you go to the Dashboard, you will see: dMC Liste check at the top of the page.…
Attachment
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
@Walcher Messebau said: It's a simple text field that contains keywords. If any of these words match with a word in the text field 'Liste', it has to flag the corresponding field in the dMC…
- Fred
- 8 mths ago
- Get help
- Reported - view
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
- 8 mths 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
- 8 mths 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
- 8 mths ago
- 1
- Get help
- Reported - view
Re: Calculate Period Progress.
@Rafael So what fields are used in the math to figure out percentage?
- Fred
- 8 mths 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
- 8 mths ago
- Get help
- Reported - view
Re: Calculate Period Progress.
Please post your code or a sample DB.
- Fred
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths ago
- Learn and share
- Reported - view
Re: GPT for Ninox
@Jacques TUR Of course you are in a train.
- Fred
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths ago
- 1
- Get help
- Reported - view

1 25 26 27 28 29 136

Welcome to the Ninox community

Fred

My Posts

Re: Is there another way to display the filtered data?

Re: Track selection of Dynamic Multiple Choice field

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: 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

Overview