Fred

San Francisco, USA

3610
568
5

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

My Posts

Latest Posts

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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: View of table sorted by date within groups
@gyannesThe -1 tells Ninox to not find anything but initialize the variable to this table. It could also probably be rewritten to be: let newArray := Handle.Players.…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Enterprise plan
I would be surprised if they removed the minimum user amount. I thought it was 5 users. If you want a private server without the minimum then Nioxus offers that.
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: View of table sorted by date within groups
Try the following for your view element code: let allPeople := (select People); let newArray := (select Rounds)[= -1]; for person in allPeople do let y := ((Handle.Players.…
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Delete view tabs
@Mel Charlesthrough the touch interface there is no right click. i have to check later on the keyboard.
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Dynamic printing and join tables
@Mel Charles don't disagree there. Their support is woefully inadequate. If Andy from Nioxius is correct, Ninox's support is shamefully understaffed for a company with enterprise aspirations.…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Delete view tabs
Welcome to Ninox. The major difference is that Ninox is based on html, so thus text, unlike FileMaker. It was developed to be browser friendly from the get go.…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: View of table sorted by date within groups
@gyannes said: I would change h to be let h:= People.Handle. Does that mean you have a reference field on the same table to People? If so then can you do: let d := People.Handle.Players.…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Dynamic printing and join tables
@Mel Charles According to Nioxius, Carbone is the print engine. Ninox is not going to build anything else.
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Dynamic printing and join tables
@AlexisO Having accented characters could be the cause. You should look into creating a JSON of the same data, that way you can create temporary field names that are not accented for the printing.
- Fred
- 9 mths ago
- Get help
- Reported - view
JSON and for loops

Hi all - I was reviewing the set() command and noticed this: for i in response do let new := (create Contacts); for key, value in i.fields do set(new, key, value) end end Look at line 3,…
- Fred
- 9 mths ago
- 63
- Get help
Re: Data Model
Things have changed. If you click the three dots next to the DB name you will see the Data Model option:
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: View of table sorted by date within groups
I'm not sure what you are trying to do with the min() command in the slice. Line 4, you ask Ninox to find the minium between 0 and a formula. If the formula is below 0 then it will select the lower…
- Fred
- 9 mths ago
- Get help
- Reported - view

1 19 20 21 22 23 145

Welcome to the Ninox community

Fred

My Posts

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?

Re: View of table sorted by date within groups

Re: Enterprise plan

Re: View of table sorted by date within groups

Re: Delete view tabs

Re: Dynamic printing and join tables

Re: Delete view tabs

Re: View of table sorted by date within groups

Re: Dynamic printing and join tables

Re: Dynamic printing and join tables

JSON and for loops

Re: Data Model

Re: View of table sorted by date within groups

Overview