Fred

San Francisco, USA

3381
534
4

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

My Posts

Latest Posts

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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths ago
- 1
- Get help
- Reported - view
Re: Duplicar archivo
@alfonso. mino. arribas Have you emailed Ninox support?
- Fred
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths ago
- Get help
- Reported - view
Re: Duplicar archivo
Are you using the app or the browser?
- Fred
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths ago
- Get help
- Reported - view
Re: How can I structure the extraction of inventory data?
@我是我的我 The second method is also quite doable. I am not talking about copying each record from the two tables, but a summary of the data from the two tables.…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: How can I structure the extraction of inventory data?
Can you merge the two tables together? It seems like the data would be exactly the same except for one or two fields. Otherwise you would have to create a button that would copy the data you want…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Scaling up - multiple users
One option is to use a website or google form that then uses some middle-ware like Zapier or Make to then make the changes to Ninox.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Why is there no response?
@我是我的我 said: What's even stranger is that the same code works fine in the database in the Public Cloud, but no data is returned offline). I'm not sure what you mean by this.…
- Fred
- 11 mths ago
- 1
- Get help
- Reported - view
Re: Why is there no response?
Looking at 1 and 2 you don't need the contains() command. Since each record in "copy here" has only 1 value for name you can do a simple equal. let s := this; select 'copy here' where name = text(s.…
Attachment
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Pop-up field showing wrong columns
It is not a bug. Just not intuitive. I haven't played around with reference field Show Field As and I notice that fields now change depending on the type selected.…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
@Rafael said: hi Fred Now this is my Code. But the problem in this example, I should only appear year 2024 but appear 2023 too. Ok, well looking at your code closer (which I didn't do very well…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
@Rafael The code looks ok to me so I don't know why you are getting records that seem to fall out side the filter. Can you upload a sample DB with no personal info?
- Fred
- 11 mths ago
- Get help
- Reported - view

1 38 39 40 41 42 136

Welcome to the Ninox community

Fred

My Posts

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

Re: How can I structure the extraction of inventory data?

Re: How can I structure the extraction of inventory data?

Re: Scaling up - multiple users

Re: Why is there no response?

Re: Why is there no response?

Re: Pop-up field showing wrong columns

Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)

Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)

Overview