Skip to main content

Ninox-Documentation

我是我的我

gold_cat

347
22
0

Joined: Thu Oct 26 02:13:26 UTC 2023

My Posts

Latest Posts

Re: Dashboard Template
@Sotirios Zormpas Hi friend, I have set the location to display in real time. How do I configure the Ninox API and write to the Ninox address? I look forward to your help.…
- gold_cat
- 4 days ago
- Learn & Share
- Reported - view
Re: Calculate Cumulative Time with Code
@Fred Thanks for reminding my friend.
- gold_cat
- 7 days ago
- Get help
- Reported - view
Re: Calculate Cumulative Time with Code
@Fred You’re right, Fred. You got the job done with as little code as possible. Thank you!
- gold_cat
- 7 days ago
- Get help
- Reported - view
Calculate Cumulative Time with Code

Hello everyone, I need a piece of code to calculate the continuous days of placing orders for sales (using weeks as the time interval). For example, today is Friday,…
- gold_cat
- 9 days ago
- 4replies
- 37
- Get help
- Answered
- Answered
Re: Dashboard Template
Hi Sotirios, is it possible to implement real-time latitude and longitude positioning and write it into the Ninox “Location” field on the map? @Sotirios Zormpas
- gold_cat
- 11 days ago
- Learn & Share
- Reported - view
Re: Regarding issues with editing the chart code
@Rafael Hi Rafael, thanks for sharing. I've reviewed your code and we have some differences. Your displayed values are associated with each date-related entry, so they are bound to the date.…
- gold_cat
- 2 wk ago
- Get help
- Reported - view
Re: Regarding issues with editing the chart code
I used AI to write the following code. It can work! But there are still some small issues. That is, for some months and dates, there is no data. However,…
- gold_cat
- 2 wk ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@Fred Great. Great. Great. Fred always finds the most efficient solutions.
- gold_cat
- 2 wk ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@Fred hi,fred. The translation contains some misunderstanding. I have uploaded the database. test.1 is method one, and test.2 is the second method that was discussed (it did not correctly output the…
Attachment
- gold_cat
- 2 wk ago
- Get help
- Reported - view
Regarding issues with editing the chart code

Hello everyone! Through studying the dashboard template Dashboard Template shared by Sotirios Zormpas, I have learned chart code. The following code already implements the display of accumulated data…
- gold_cat
- 2 wk ago
- 3replies
- 45
- Get help
Re: How to write code for data filtering?
@我是我的我 said: Feb 29, 2024, 22:04 Feb 29, 2024, 22:14 Mar 1, 2024, 08:11 Mar 1, 2024, 08:13 Mar 1, 2024, 08:17 Mar 1, 2024, 08:21 @Fred Yes, Fred. My question is also a discussion.…
- gold_cat
- 2 wk ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@Fred said: renaming the date + time field to just time is confusing That's the problem. If I simply add date(), there's no constraint, and all times will appear.
- gold_cat
- 2 wk ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@Fred Hello, I didn't clearly express my thoughts yesterday. What I wanted to say is: apart from the method I mentioned of creating a conversion function in the referenced time table,…
- gold_cat
- 2 wk ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@Fred Yes, my ideas are greater than my practical ability. But thank you for your help.
- gold_cat
- 3 wk ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@Fred This part, the `yearmonth()` function does not support time group conversion. How can I use the `yearmonth()` command? In actual situations, I also need to include the day in the date, that is,…
- gold_cat
- 3 wk ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@Fred Thank you for the help~
- gold_cat
- 3 wk ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@Fred Thanks for Fred's reply. I may not have expressed my question clearly before. For the first question, I have calculated the total sales volume of each employee.…
Attachment
- gold_cat
- 3 wk ago
- Get help
- Reported - view
How to write code for data filtering?

How can we filter out the top three salespeople with code? Xiao Ru $382.00 Jiang Ningwei $648.00 Xiao Ru $1,704.00 Jiang Ningwei $2,883.00 Xiao Li $11,760.00 Yang Daibing $4,640.00 Li Yanping $980.…
- gold_cat
- 3 wk ago
- 18replies
- 127
- Get help
- Answered
- Answered
Re: Dashboard Template
@Sotirios Zormpas Hi, friend! I want to connect the data from the database to the following chart. I have tried many times. Can you help me? If possible, I also want to connect all the data.…
Attachment
- gold_cat
- 3 wk ago
- Learn & Share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas thanks'
- gold_cat
- 3 wk ago
- Learn & Share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas Hi friend, maybe the translation didn’t quite capture what I meant. I’ve made the following GIF to show what I mean. When the map is zoomed out to the smallest level,…
- gold_cat
- 3 wk ago
- Learn & Share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas Is it possible to display only one map overall, regardless of the zoom level?
- gold_cat
- 3 wk ago
- Learn & Share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas It seems more complicated than I thought. Could you please help me with another question? How can I set the map to display only the global range,…
- gold_cat
- 3 wk ago
- Learn & Share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas Hello friend, I have added the "cluster maps" feature into the code below, but it doesn't display the aggregated statistical numbers. What could be the problem? let _accounts :…
- gold_cat
- 4 wk ago
- Learn & Share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas I forgot this step, thank you
- gold_cat
- 1 mth ago
- Learn & Share
- Reported - view

1 2 3 4 5 14

Back to top

Ninox-Documentation

Overview

View all topics