Rafael

Rafael_Sanchis

Rafael Sanchis

Madrid - Spain -

1137
123
1

Joined: Wed Mar 02 18:44:14 UTC 2022

Architect & Senior Project Control Scheduler.

My Posts

Latest Posts

Re: Need Help to create a History Control Table
@Fred I have Reference form CONTROL_TABLE to DOCUMENTOS 1:N
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Fred Screenshot, The Documentos Table, Control_Table and Transmittal button
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Fred Hi Fred I have Problem on line 29 (Field not found months at line 29 column 19 I change the months for my name table CONTROL_TABLE but the error is the same.…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Fred No with that Code no go anywhere. The idea is when I place a Date in FechaR3 this Document need to copy to the table CONTROL_TABLE, with the Code and the FechaR3,…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Fred Thanks Fred I'll start with this
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Fred Hi Fred no I have no idea how to start, all I have is the Table ControlTable with the fields I need, Document, Cose, and DateR3, DateR4 and DateR5.…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: MultiLine Text field with multiple rows alongside in form
@Bernd Krell Hi again I saw is a sample DB you can Share?
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: MultiLine Text field with multiple rows alongside in form
@Bernd Krell Hi Bernd your Code Works fine
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Need Help to create a History Control Table

I need a Control Table, where every time the FechaR3, FechaR4 and FechaR5 are met in the Documents Table, they are copied to the Control Table with the Document Name, the Code and all 3 Dates.…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- 21replies
- 174
- Get help
- Answered
- Answered
Re: MultiLine Text field with multiple rows alongside in form
@Jacques TUR Fabulous Jac, Thanks
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Seems basic math and date function are bugged
@John Halls Hi John, I find these script and work fine, there are any way to Add a HOLIDAY in this script ? Thinking in one Table only Holidays. Thanks
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: The number of days in each month of the day period and its total
@Paul Chappell Yes very sorry and Thanks
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: The number of days in each month of the day period and its total
@Paul Chappell Hi Paul Your formulas don't give any result, after include the Formula at the end of same formula include void and any result. (let LastDayOfMonth := date(year(Fecha_Real),…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Wish List or can the great Jacques pull one out of the hat
@Alex Thanks Alex
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Wish List or can the great Jacques pull one out of the hat
@Alex Yes work, but when change from tab to tab lost the color. Is normal or need more html code ?
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Custom HTML Dashboard
Thanks for the clear explanación Alex.
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Custom HTML Dashboard
How much of that code really needs to be programmed? There are more than 700 lines for four easy KPI'S, if you need the Earned Value, Total Cost, CPI, SPI, EAC, ETC is to leave life
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Custom HTML Dashboard
@Alex Thanks Alex very grateful for sharing this info
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Normalising existing data
@Fred Everything is working fine Fred, I work with other models and everything works fine, sorry for so much inconvenience. Thanks
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Fred I send the DB the Formula is on Tooltip for copy and place on click. I Will continue tomorrow Thanks Fred
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Fred with this formula let selAliaxis := (select DB_Aliaxis); let Array1 := unique(selAliaxis.ProveedorOld); for loop1 in Array1 do let newRec := (create Proveedores); newRec.…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Fred Hi again Fred, I try with another DB and the following error message appear. Am I doing something wrong or am I missing something.
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Fred Great Fred This is Just I needed, to implement in my project for when I import from Excel the file and I have a longitud List of documents, keep the table of Disciplines crean and have the link…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Fred 1) I have a table (AlbumsCards) that has duplicate data in a field (Teams) 2) now I want to take the data in the Teams, strip out the duplicates and create a new table (AlbumsCards2) that has a…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Fred Hi Fred I import a spreadsheet of AlbumCards about European Fotball. The AlbumCards have the Field Teams that has duplicate data. What I need the point 2 and 3 of yours explanation,…
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view

1 31 32 33 34 35 46

Welcome to the Ninox community

Rafael

My Posts

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: MultiLine Text field with multiple rows alongside in form

Re: MultiLine Text field with multiple rows alongside in form

Need Help to create a History Control Table

Re: MultiLine Text field with multiple rows alongside in form

Re: Seems basic math and date function are bugged

Re: The number of days in each month of the day period and its total

Re: The number of days in each month of the day period and its total

Re: Wish List or can the great Jacques pull one out of the hat

Re: Wish List or can the great Jacques pull one out of the hat

Re: Custom HTML Dashboard

Re: Custom HTML Dashboard

Re: Custom HTML Dashboard

Re: Normalising existing data

Re: Normalising existing data

Re: Normalising existing data

Re: Normalising existing data

Re: Normalising existing data

Re: Normalising existing data

Re: Normalising existing data

Overview