Fred

San Francisco, USA

3602
566
5

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

My Posts

Latest Posts

Re: Need help organizing some information
@BuffaloTony said: "Day 1" "Day 2" etc (ultimately I would like there to be 8 days total, as, historically this has been all i would need to schedule. Just a reminder that duplicating field names…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
Here is a first go at the code: Attached is the modified DB. I created a new table called Labor as I needed dates and people linked. I couldn't figure out a way to programmatically create columns in…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony can you upload a sample DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony There are ways. If you want to see something like this it would probably take some html/CSS coding. Are you using the app or the public cloud?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
That looks great. You have done a great job. @BuffaloTony said: I have a relationship table setup in each job that shows which assistants I have employed oone additional field,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: I need to iterate a json object.
@CISOFT Sàrl You are mixing up commands from the dynamic print engine and regular Ninox commands. You wrote: function createLog(object:any) do let mylog:=""; let sep:="|"; for i in range(0,cnt(object.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Need help organizing some information
Welcome to Ninox,@BuffaloTony . Welcome to the world of relational database. It is a very different world than the flat spreadsheet world, so be open to unlearning what you are use to.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Export file excel in a subtable.
@Nguyen Nhat Dong Take a look at this post.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: createXLSX
Had a chance to play around a bit and you can build your JSON dynamically. In my test DB i have the following code for the rows variable: let rows := (select InvoiceItems).[{ name: Products.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: createXLSX
Those look like Excel formulas. Which makes sense as you are creating Excel files. Which means you need to map out the columns and rows in your mind or in an test Excel file so you can see the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: I need to iterate a json object.
@CISOFT Sàrl Just to clairfy, are you trying to use JSON in a formula or in a dynamic print page? I ask because your first post refers to dynamic printing.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: I need to iterate a json object.
can you post your code?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: The problem of writing N:1 code.
@我是我的我 so you will need a for loop. Remember a previous post of yours where we went over for loops. Take a look at it and try to come up with the code. Even if you get an error,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
@john cesta are you in admin mode? regardless, you still have the issue of the Table2 reference field.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
@john cesta the joys of modern life.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
@john cesta did it work?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: The problem of writing N:1 code.
@我是我的我 if you only will have 1 linked record then you can use the first() command. 'Y/N' := first(copy.'Y/N')
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: 3.12 webinar link
@Alan Cooke I never hold my breath for anything Ninox does. It allows me to be "pleasantly" surprised.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: The problem of writing N:1 code.
I'm guessing that copy is the N and HOME is the 1? How do you want to handle when you have multiple records in copy that is linked to 1 HOME. This is the big question.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: 3.12 webinar link
I guess now we wait for the repost on YouTube.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Export file excel in a subtable.
Looks like in 3.12, there will be the ability to export to excel through code, createXLSX().
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Export file excel in a subtable.
@Nguyen Nhat Dong I don’t think so. There is no way that I know to set the filter of a table view column. You might want to consider using a view element.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
these error icons on your tables/pages is a start to your troubleshooting. Then when you open the table you will see Table2 also in red.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
After poking around it looks like there is a reference field in two tables and a Page ('What is a page', writtenbiz, and TODO) that is broken and can not be deleted.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
@john cesta wow. They use to do email support for all customers. I just checked and now basic does not provide any support at all. you can try Nioxus, but there will be a fee.
- Fred
- 1 yr ago
- Get help
- Reported - view

1 38 39 40 41 42 145

Welcome to the Ninox community

Fred

My Posts

Re: Need help organizing some information

Re: Need help organizing some information

Re: Need help organizing some information

Re: Need help organizing some information

Re: Need help organizing some information

Re: I need to iterate a json object.

Re: Need help organizing some information

Re: Export file excel in a subtable.

Re: createXLSX

Re: createXLSX

Re: I need to iterate a json object.

Re: I need to iterate a json object.

Re: The problem of writing N:1 code.

Re: Error: Type not found: I when printing

Re: Error: Type not found: I when printing

Re: Error: Type not found: I when printing

Re: The problem of writing N:1 code.

Re: 3.12 webinar link

Re: The problem of writing N:1 code.

Re: 3.12 webinar link

Re: Export file excel in a subtable.

Re: Export file excel in a subtable.

Re: Error: Type not found: I when printing

Re: Error: Type not found: I when printing

Re: Error: Type not found: I when printing

Overview