Rafael's Profile | Ninox community

Badges

Latest Posts

Re: Calculate Period Progress.
@Fred 'Earned Value EV' / 'Total Budget BAC' * 100
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Calculate Period Progress.
@Fred Fred too simple but something like this date or week as reference let date1 := "May 17, 2024"; let percentage1 := 35; let date2 := "May 24, 2024"; let percentage2 := 42;…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Calculate Period Progress.
On Setting Data Date on green button Update Progress Report Graph. Each Friday delete both report and generated again with the new data @Fred
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Calculate Period Progress.
@fredo ok no idea Fred no code. I send the DB, first image. Progress-Cost Report is genereted by a script. Now need the formula to calculate the period progress. in this DB the 32.54% - 23.…
Attachment
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Calculate Period Progress.

Need Calculate the Period Progress. Example: the Period Progress of: 17 May 2024 is 14.64 % 23.77 % - 9.12 %
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- 12replies
- 82
- Get help
- Answered
- Answered
Re: Analysis of your database structure with Ninext
The Ninox Low Code 😲
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
@fredo I use in Formula field and works perfect
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- 2
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
@Jacques TUR 😱 👍
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
@Jacques TUR
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
@Jacques TUR Hi Jacques I'm doing something wrong since I don't see the information as you showed it.
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
@Jacques TUR Yiu are right Sorry
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
@Jacques TUR 👍 find it Thanks.
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
@Jacques TUR Jacques when run ninext on Documents give me a error, if no run Ninext no error. 😮
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Analysis of your database structure with Ninext
My DB
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Send Email on Click Error
The "html" parameter is no longer optional and must be specified. Then the problem is solved. Just insert it like this and it will work again: html:"",
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Need Script for transfer Dates
@Fred Hi Fred. let xResponse := dialog(" ADD Real Date To Forecast Table (one by one) ", "Do you want to ADD Real Dates To Forecast Table for Re-planning ?", ["Yes", "CANCEL"]);…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Need Script for transfer Dates
@fredo hi Fred, let xResponse := dialog(" ADD Real Dates To Forecast Table ", "Do you want to ADD Real Dates To Forecast Table for Re-planning ?", ["Yes", "CANCEL"]);…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: Need Script for transfer Dates
@Fred There are any way to do this
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: createXLSX: format column as currency
@Andy Work Perfect
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Learn and share
- Reported - view
Re: Send mail with attachments
The "html" parameter is no longer optional and must be specified. Then the problem is solved. Just insert it like this and it will work again: html:"", Something like this needs to be communicated in…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Need Script for transfer Dates

Hi Fred again with problems, I feel like I'm. going backwards. On the Documents I have Two Buttons ADD Documents One by One and the other ADD ALL Documents and Works excelent.…
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- 5replies
- 77
- Get help
- Answered
- Answered
Re: I Need to update field in another table.
@Fred Hi Fred maybe very easy but can,t find the solution.
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: I Need to update field in another table.
Yes the projCod is a text field I can't find the script
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
Re: I Need to update field in another table.
@Fred hi Fred. let myTable1 := Id; let myText := projCod; for i in (select 'Control Deliverables')[projCod = myText] do i.(projCod := myTable1) end I try this but don't work something wrong.
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Get help
- Reported - view
I Need to update field in another table.

I Need to update field in another table. On Document I have te 'projCod' field and need to update on table 'Control Deliverables' on fleld 'projCod' only update no duplicate.
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- 7replies
- 99
- Get help
- Answered
- Answered

1 14 15 16 17 18 53

Welcome to the Ninox community

Rafael

Re: Calculate Period Progress.

Re: Calculate Period Progress.

Re: Calculate Period Progress.

Re: Calculate Period Progress.

Calculate Period Progress.

Re: Analysis of your database structure with Ninext

Re: Analysis of your database structure with Ninext

Re: Analysis of your database structure with Ninext

Re: Analysis of your database structure with Ninext

Re: Analysis of your database structure with Ninext

Re: Analysis of your database structure with Ninext

Re: Analysis of your database structure with Ninext

Re: Analysis of your database structure with Ninext

Re: Analysis of your database structure with Ninext

Re: Send Email on Click Error

Re: Need Script for transfer Dates

Re: Need Script for transfer Dates

Re: Need Script for transfer Dates

Re: createXLSX: format column as currency

Re: Send mail with attachments

Need Script for transfer Dates

Re: I Need to update field in another table.

Re: I Need to update field in another table.

Re: I Need to update field in another table.

I Need to update field in another table.

Overview