Fred

San Francisco, USA

3747
594
5

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

My Posts

Latest Posts

Re: How to write code for data filtering?
@我是我的我 said: test.2 is the second method that was discussed (it did not correctly output the total for the specified date). You wrote: let getCopy := (select Data); let Onlyname :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 Using the DB you uploaded, are you saying: date(time) doesn't give you just the date?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 I’m talking about just the name of the date+time field.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna Please mark the post answered.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: goto another record from calendar
You may have to look into@Sotirios Zormpas great html calendar in his dashboard post. Since it is HTML based you can probably redirect to where you want to go.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna use@John Halls
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@John Halls Of course, I put my parenthesis in the wrong place. I was trying to do something like this. Thanks for the simpler way.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@John Halls I get an function not defined error message of number, number, string.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 said: is there another way to achieve the functionality I mentioned by only editing the code? Using the DB you attached, if you wanted to search for only two dates in the Data table you could…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Delete view tabs
@Kate What version of the app are you using? I'm on 3.13.6 and have no issues. I can two finger click a view or I can control click on a view and I get the submenu.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna Silly me. I didn't follow the docs myself. You can only use numbers in datetime(). So you have to do a bit of math to get the hour and minutes into a human readable form.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
That is because you didn’t tell Ninox what time to add. Try: date+time field := date(year(date+time), month(date+time), day(date+time) + 7,time(date+time); Here is the documentation for datetime().
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic printing and join tables
@AlexisO i’m sorry. i thought you were going to use a json so you can use dynamic printing. what is still not working for you?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Print Report Layout
I just updated and was able to access the print layout in both local DB and iCloud DBs.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Avoid new records
@Pascal P. It seems like it is a bit late to pop up a message after the new record is created, but let me answer your question. Be aware that once you move your DB into the cloud for multi-user…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Avoid new records
@Pascal P. Is this in a button? Is this in a dashboard? Or in a data table? Are you checking another table or the current table?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic printing and join tables
@AlexisO , if you were able to get your question answered, please mark the post answered when you have a moment.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 said: I also need to include the day in the date, that is, for example, 2024/9/13 It is hard to keep up with the changing requirements. If you need the date from a date + time field then…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: View of table sorted by date within groups
@gyannes When you get a chance, please mark the post answered.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic printing and join tables
@RoSoft_Steven If they can imbed Carbone Studio into Ninox then it will make the whole process easier. For those who haven't tried it, here is what studio looks like. It is free so give it a try.…
- Fred
- 1 yr ago
- 2
- Get help
- Reported - view
Re: View of table sorted by date within groups
@gyannes try this: let allPlayers := (select Players); let newArray := (select Rounds)[= -1]; for player in allPlayers do let a := (player.handle.Rounds order by today() - 'Date Played'); let b :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 said: I only need to use code to filter and display as 2024/9 and 2024/10. How can this be achieved? Look into the yearmonth() command. Create a new formula field with the command.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 1) try: let getCopy := (select Data); let Onlyname := unique(getCopy.name); let newData := (for loop1 in Onlyname do let TotalSales := sum(getCopy[name = loop1].…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
The second one is a filtering question, so you could do something like: [datefield = date(2024, 2, 9) or datefield = date(2024, 3, 1)]
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
Look at this reply to see an example of order by. Look at the full post to see an example of slice(). If you still need help, please post your code?
- Fred
- 1 yr ago
- Get help
- Reported - view

1 24 25 26 27 28 150

Welcome to the Ninox community

Fred

My Posts

Re: How to write code for data filtering?

Re: How to write code for data filtering?

Re: How to write code for data filtering?

Re: adding eg 7 days to a date+time field

Re: goto another record from calendar

Re: adding eg 7 days to a date+time field

Re: adding eg 7 days to a date+time field

Re: adding eg 7 days to a date+time field

Re: How to write code for data filtering?

Re: Delete view tabs

Re: adding eg 7 days to a date+time field

Re: adding eg 7 days to a date+time field

Re: Dynamic printing and join tables

Re: Print Report Layout

Re: Avoid new records

Re: Avoid new records

Re: Dynamic printing and join tables

Re: How to write code for data filtering?

Re: View of table sorted by date within groups

Re: Dynamic printing and join tables

Re: View of table sorted by date within groups

Re: How to write code for data filtering?

Re: How to write code for data filtering?

Re: How to write code for data filtering?

Re: How to write code for data filtering?

Overview