slayer1957
Board Regular
- Joined
- Jan 9, 2017
- Messages
- 50
Good day,
I have a next step list where each next step listed has a comment section in column G, the comment section is usually only one cell with the text. Every meeting the feedback must be captured with today's date then feedback from the project manager and then if next step is not completed it must up the revision of the next step which is in column E and comment must be added
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]Estimated completion date[/TD]
[TD]Revision[/TD]
[TD]Completed Y/N[/TD]
[TD]Comments/Feedback[/TD]
[/TR]
[TR]
[TD]31/12/2019[/TD]
[TD]rev04[/TD]
[TD]No[/TD]
[TD][TABLE="width: 312"]
<tbody>[TR="class: grid"]
[TD]10/08/2018-Arranged a meeting with instruments for possible solutions. Currently no as-builts.
12/11/2018- Discuss with instruments to tie in to the PLC, get drawings updated and have session to discuss possible tie-ins.
13/02/2019- Red line drawings to be updated
13/05/2019- Follow up if next step is still needed[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]25/12/2019[/TD]
[TD]rev05[/TD]
[TD]No[/TD]
[TD][TABLE="width: 312"]
<tbody>[TR="class: grid"]
[TD]30/8/2018- APT study completed. Awaiting final recommendation from Electrical engineering.
10/08/2018-Waiting for inventory to make final call.
12/11/2018 - Was presented and approved at inventory governance for a spare.
13/02/2019- Presented and 1 was allocated
13/05/2019- Confirmed 2 to be spare, Move one at substation to store, follow up meeting on 17 May 2019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I need to try and do this with a popup message and input the data and let it save as the example, for instance i click on cell of the comment/feedback on the specific meeting day (today), it must popup a text box and feedback must be written and it must save it as continuation of the current cell text.
Can this be done?
I have a next step list where each next step listed has a comment section in column G, the comment section is usually only one cell with the text. Every meeting the feedback must be captured with today's date then feedback from the project manager and then if next step is not completed it must up the revision of the next step which is in column E and comment must be added
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]Estimated completion date[/TD]
[TD]Revision[/TD]
[TD]Completed Y/N[/TD]
[TD]Comments/Feedback[/TD]
[/TR]
[TR]
[TD]31/12/2019[/TD]
[TD]rev04[/TD]
[TD]No[/TD]
[TD][TABLE="width: 312"]
<tbody>[TR="class: grid"]
[TD]10/08/2018-Arranged a meeting with instruments for possible solutions. Currently no as-builts.
12/11/2018- Discuss with instruments to tie in to the PLC, get drawings updated and have session to discuss possible tie-ins.
13/02/2019- Red line drawings to be updated
13/05/2019- Follow up if next step is still needed[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]25/12/2019[/TD]
[TD]rev05[/TD]
[TD]No[/TD]
[TD][TABLE="width: 312"]
<tbody>[TR="class: grid"]
[TD]30/8/2018- APT study completed. Awaiting final recommendation from Electrical engineering.
10/08/2018-Waiting for inventory to make final call.
12/11/2018 - Was presented and approved at inventory governance for a spare.
13/02/2019- Presented and 1 was allocated
13/05/2019- Confirmed 2 to be spare, Move one at substation to store, follow up meeting on 17 May 2019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I need to try and do this with a popup message and input the data and let it save as the example, for instance i click on cell of the comment/feedback on the specific meeting day (today), it must popup a text box and feedback must be written and it must save it as continuation of the current cell text.
Can this be done?