Fred

San Francisco, USA

3376
533
4

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

My Posts

Latest Posts

Re: Ninox E-Invoicing
Is this for both public and private cloud?
- Fred
- 3 mths ago
- Learn and Share
- Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Is the Muliple Choice field in Table1 a simple or dynamic field?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Mimic spreadsheet
@gyannes Glad to hear it works out. When you have a moment, please mark the post answered.
- Fred
- 3 mths ago
- Learn and Share
- Reported - view
Re: Mimic spreadsheet
One possible solution is attached. I'm not very good with Ninox charts so hopefully someone who is more knowledgable can help out there. I'm sure you can do something like you post in an html table.…
Attachment
- Fred
- 3 mths ago
- Learn and Share
- Reported - view
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
- 3 mths 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
- 3 mths 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
- 3 mths ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna Please mark the post answered.
- Fred
- 3 mths 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
- 3 mths ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna use@John Halls
- Fred
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths ago
- Get help
- Reported - view

1 9 10 11 12 13 136

Welcome to the Ninox community

Fred

My Posts

Re: Ninox E-Invoicing

Re: Dynamic multi-selection in the subform: Display of selected and unselected items.

Re: Mimic spreadsheet

Re: Mimic spreadsheet

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

Overview