Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

Re: Warning on button coding: "Field must return dynamic values..."
can you post a sample DB, one without personal data?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to use code to edit out unique non-repeating random numbers?
@我是我的我 I'm not sure what you want to do. You ask to "edit out unique non-repeating random numbers". Then you give a string that has numbers and letters.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to use code to edit out unique non-repeating random numbers?
Can you provide a sample of the data?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after update & Alert anomaly
@spinner. 7580 Sorry if I gave the impression to wrap the script in a do as server. That will definitely make any script with an alert() function not show up.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn
But to answer your first question. You can put this in the dynamic field in Audit Plan. let t := this; select 'Phases to Audit' where 'Areas to Audit'.Areas = t.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn
@Rafael I'm talking about adding one under Audit Plan.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn
Just wondering, shouldn't there be a Phases subtable of Audit Plan? You would create a new record for each phase to be audited? That way you can update each phase as they are audited?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dropdown menu on database icon not working
Once they made the app free, I saw that as a sign that it will not always be updated as quickly as the browser version. So I made the leap to a public cloud account.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox will not open on my Mac
Try: Quit the Ninox app. open Terminal put this in the terminal app: defaults delete de.ninoxdb.ninox-mac.Ninox
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after update & Alert anomaly
@spinner. 7580Steven's link shows you where the action happens depending on where you make the call. So it says a Trigger after update happens at the server level for browsers and at the client level…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Date format in formula
check out the Ninox doc on date(), you will see the proper date format of date(year, month, day).
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
@John Halls Very clever way of creating unique instances. I would have created three new variables to do the same thing.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
you can also do: let t := 'Enrolled Date'; switch true do case Withdrawn = 0 and Graduated = 0: days(date('Enrolled Date'), today()) - cnt(select 'Academic Breaks' where Date >= t and Date <=…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Duplicar archivo
@alfonso. mino. arribas Have you emailed Ninox support?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after update & Alert anomaly
I think you are running into the issue that Triggers happen at the server level so no alerts show to the end user. It is like wrapping your code with [do as server].…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How can I adjust this?
@我是我的我 said: I don't quite understand Fred. My initial selection was "Alcohol". The final table includes "beverage", which should be incorrect. I don't see beverage unless I select beverage.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Duplicar archivo
Just to be clear you are trying to duplicate a record? Are you using the duplicate button? I tried it on a public cloud DB and had no issue.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How can I adjust this?
If you put the following code in a new formula field: let s := this; let y := for loop1 in numbers(xxx) do record('copy here',loop1).name end; let x := (select 'copy here' where (var n := name;…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create record in another table on a switch
@Linda said: Klanten is a reference field in Reiskosten. But Klant(en) has a link in the table: Opdrachten. So when I make a new record in Uren, I choose a record from Opdrachten.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Duplicar archivo
Are you using the app or the browser?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How can I create a dynamic multiple choice that uses selections from another dynamic multiple choice.
Here is a third option that does not use the dreaded select statement. let selected := numbers(MC1); for loop1 in selected do record(Table1,loop1) end
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How can I create a dynamic multiple choice that uses selections from another dynamic multiple choice.
That is an interesting question. I'm not sure why you need another dMC showing the selection of a previous dMC, but what the heck why not do it. Try: let selected := numbers(MC1);…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Distribute dates between two others days.
@Rafael is there a pattern for your plan days? do you want always on a specific day of the week? Is 25% a week later than Plan 1? Is 90% a week before Plan 5? Give it think and let me know.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Distribute dates between two others days.
wow, that is a tricky ask. You would first need a table of holidays since Ninox has no way of knowing what holidays you follow. Then you would need to figure out how many days 25%,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create record in another table on a switch
Welcome to Ninox. If I make a new record in this table [Uren] and set the switch on "Yes", I want to, automatically create a new record in another table [Reiskosten].…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 47 48 49 50 51 145

Welcome to the Ninox community

Fred

My Posts

Re: Warning on button coding: "Field must return dynamic values..."

Re: How to use code to edit out unique non-repeating random numbers?

Re: How to use code to edit out unique non-repeating random numbers?

Re: Trigger after update & Alert anomaly

Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn

Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn

Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn

Re: Dropdown menu on database icon not working

Re: Ninox will not open on my Mac

Re: Trigger after update & Alert anomaly

Re: Date format in formula

Re: Help with Changing Multiple If Statement to a Case Statement

Re: Help with Changing Multiple If Statement to a Case Statement

Re: Duplicar archivo

Re: Trigger after update & Alert anomaly

Re: How can I adjust this?

Re: Duplicar archivo

Re: How can I adjust this?

Re: Create record in another table on a switch

Re: Duplicar archivo

Re: How can I create a dynamic multiple choice that uses selections from another dynamic multiple choice.

Re: How can I create a dynamic multiple choice that uses selections from another dynamic multiple choice.

Re: Distribute dates between two others days.

Re: Distribute dates between two others days.

Re: Create record in another table on a switch

Overview