Fred

San Francisco, USA

3381
533
4

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

My Posts

Latest Posts

Re: Since Latest Upgrade I Can't Do Anything!
For your MacOS app you can do: Terminal command please try the following to fix the problem: open the Terminal app You can find it via Spotlight search,…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: This is a beginner but I haven't been able to figure it out.
Take a look at this post. Give it a try and let us know if you have any further questions.
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony said: is it not possible to do something like: let datacolor := color(DayPosition) I didn't even know color() was a command. Thanks for showing me it. That is a great use of the command.…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Need help organizing some information
Messing around a bit more I got this: with this code: let getLaborData := (Labor order by Date); let getUniqueDates := unique(getLaborData.Date); let data := for loop1 in getUniqueDates do { date:…
- Fred
- 9 mths ago
- Get help
- Reported - view
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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony can you upload a sample DB?
- Fred
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: Export file excel in a subtable.
@Nguyen Nhat Dong Take a look at this post.
- Fred
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Learn and share
- Reported - view
Re: I need to iterate a json object.
can you post your code?
- Fred
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
@john cesta the joys of modern life.
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
@john cesta did it work?
- Fred
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: 3.12 webinar link
I guess now we wait for the repost on YouTube.
- Fred
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view

1 29 30 31 32 33 136

Welcome to the Ninox community

Fred

My Posts

Re: Since Latest Upgrade I Can't Do Anything!

Re: This is a beginner but I haven't been able to figure it out.

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: 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.

Overview