Rafael's Profile | Ninox community

Badges

Latest Posts

Re: Cross Tab in a Form
@John Halls This is good example. The Problem is the Formula Field don't have scroll bar or fix colum.
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: HTML Report
@Mel Charles As Usual with Ninox Support 😔
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@John Halls Hi John. One question I change the Col for Week and Row for Activities and Value for Cost. In the example is ok work perfect. But in my DB the Activities is on other Table and have…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@John Halls The idea look good, I think is very difficult no value 0 and the graphics can't grouped by Wxx
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 1
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@John Halls Look Great, and with only change the Name Col, Row for Row and Col is ok no need change code. I can have few Week on Column but many Activities on Row. Thanks
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
😂 obviosly, Work perfect. There any way to change the rows and colum by the original options. ?
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@John Halls where you place the formula ?
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@John Halls Thinkings in Hours by Activitie.
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@John Halls Thank 😔obviosly don't create the parent table Thanks 👍
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
Very interesting. Can you Share the DB, I try to recreate it, but the code give me error, I'm doing something wrong.
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: sum((select......... with two values
@Fred 👍
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
HTML Report

Hi all. There are any way to create on Ninox a HTML report like this, there are some examples here. Thanks.
- Rafael Sanchis
- Rafael_Sanchis
- updated 4 yrs ago
- 3replies
- 196
- Learn and share
Re: sum((select......... with two values
@Paul Chappell Yes work thanks Paul 👍
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
sum((select......... with two values

Hi, I try to use this formula but don't work sum((select Line).Plan_Earned_Act_E; Plan_Earned_Act_P) or sum((select Line).Plan_Earned_Act_E + Plan_Earned_Act_P)
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 6replies
- 196
- Get help
- Answered
- Answered
Re: Suggestions from May 2022
I want the chart to NOT plot the null values FIX this
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Suggestions from May 2022
Lost Radio Button, duplicate it on the MacOS, Android & Web, app on v3.6.6. Just to be clear this only happens on reference fields. Fix this.
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Learn and share
- Reported - view
Re: Suggestions from May 2022
The most important thing here is that Ninox solves the bugs first, and then at least Plan some of these ideas and make them come true at least one or two
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 1
- Learn and share
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Great , Thanks very interesting explanation John
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Hi John, some technical for me 👍 maybe work for me because each time I cutoff I delete ALL the Progress Table and generate all New one. I have Two button on Table CUTOFFDATE when finish…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Hi again John, Early this morning on my mockup I was working, I have 9 cutoffdates in my DB, I do 18 cutoff and work fine in all. I will try again in afternoon.…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Hi John, thanks for new ideas, so far it's working fine, if you have any better ideas you'll be welcome, I have no idea of programming, it's taken me a long time to get to where I am…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred Great Fred Now Have the Cost by Week and the Cumulative Cost and can represent the Curve with the Plan - Earned and Cumulative Cost Thanks Fred.
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@John Halls Thanks John appreciate.👍
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred Yes Fred Work Great Work. 👋 Thanks a lot
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Fred Yes Fred is EVM-7-1_Junio.Ninox Upload again
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view

1 43 44 45 46 47 54

Welcome to the Ninox community

Rafael

Re: Cross Tab in a Form

Re: HTML Report

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: sum((select......... with two values

Re: sum((select......... with two values

sum((select......... with two values

Re: Suggestions from May 2022

Re: Suggestions from May 2022

Re: Suggestions from May 2022

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Overview