Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Design Table for WBS
Hi Fred let me 2 day and I send you a copy of another DB with all plan Dates by Documents and Real dates by Documents. Is a small project a maybe more easy to you understand on this project you can…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: Design Table for WBS
@Fred Hi Fred, I use these methodology for years in excel and work perfect, and now I will like to work it in a Database. I need to cutt-off every week 9,10,…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
@Fred Thanks Fred sorry the last chance. Is use then else for each FechaP1, FechaP2, FechaP3, Fecha P4 with the same formula ? sum((select Documentos)[week(FechaR1) = 9].'Horas Ganadas Plan')
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
😪 no working I try with one document 670 hors, with different Dates 04/03 11/03 18/03 an 25/03 and place all in semana 9 For 10% 04/11 67 hours For 45% -10% 11/03 234.5 hours For 70%-45% 18/03 167.…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
@Fred Maybe let me try
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
The idea is with the Hours week by week create that The Green curve is the Plan an the blue is the Real. The FechasP1 No change in the live of the projet.
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
@Fred Yes I used the the FechaP1 to P4, PlanDates, these dates are the time take the document to delivery for the 4 Milestones. The Fechas R1 to R4 are the Real Date.…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
Hi Fred I send you my DB 1. First the tablet FechaCorte is where I change every week the cut-off date and the date is copied in all documents. 2. Hitos is where I define the Milestones for document…
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
@Fred Hi FredI, I need cutoff every friday to know the earned hours, in the first graphic in the week 9 I earned 1.848 and in the week 10 I earned 924 hours but the problem is sum week 9 and 10 and…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: What means these mensage.
Ready 👍Thanks a lot
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
What means these mensage.

Hi what these mensage means, these error simbol ? only apearse in design view, but all work good.
- Rafael Sanchis
- Rafael_Sanchis
- updated 4 yrs ago
- 2replies
- 27
- Get help
- Answered
- Answered
Re: Design Table for WBS
@Rafael Sanchis @Fred Excelent Fred work excelent only need eliminate the Project Table I need consult you about Formula that not working is Posible ?
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
@Fred Whommm excelent you help me a lot appreciate yor time thanks again 👌
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: Design Table for WBS
@Fred You said something like that.
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
@Fred 1) it looks like a document can only belong to 1 Gerencia or 1 Area or 1 Sub Area or 1 Subsytem never all at the same time. Yes is correct 👍 MainCategory where you would choose Gerencia, Area,…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: Design Table for WBS
@Fred Good morning. That is my WBS I can have many Documents for each level Example Evaluación técnica Ofertas de accesorios de tuberías soldados a tope.…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
@Fred My feeling here is that Area, SubArea, and SubSystem are more fields for a record in Documents. Ok Fred, I'm going to take some time to review this alternative.…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
What separates Project from WBS Project? Can 1 Project have multiple WBS Projects? The project need multiples WBS yes
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
Here you can see the WBS Area have 6 diferent areas and in each area there are different Documents with different disciplines. The same for the Subarea and Subsystem.…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
That is my DB is one for Project. Tablet Project 1 to Many to the 4 WBS I have 4 tablets WBS relations 1 to Many to the table Documents (can have 2000 Docs easy) example one discipline can have Many…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: Design Table for WBS
@Fred Yes Fréd is doing what I want only the idea is there are something more to optimazed the relation between tablets. Many thanks
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Formula don't give anything
Works, thanks a lot @John Halls
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Formula don't give anything

These Formula don't give me anything, any idea. let x := (select Documentos where Semana = 9); if Week = (select Documentos).Semana then sum(x.'Horas Ganadas Plan') end Thanks
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- 2replies
- 38
- Get help
- Answered
- Answered
Re: Design Table for WBS
Ninox Projects DB template is too simple
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
I the image the first 4 tablets are the WBS, the second is Area WBS and I have 6 Áreas each Area have the associate products by Disciplina. The Subarea WBS have 4 diferent Subarea with diferents…
- Rafael Sanchis
- Rafael_Sanchis
- 4 yrs ago
- Get help
- Reported - view

1 47 48 49 50 51 52 53

Back to top

Overview

View all topics