project time management

what do you want to add? more hours to an existing line? a new line to the portal?

thank you, lesouef:)

do you think i can make like this?
http://www.angelakello.com/hiro/Snap2.gif
http://www.angelakello.com/hiro/test.fp7

can you give me an example?

I don't have enough info to do it:
- is the report relevant of the person or the project?
- is the amount of time per project a sum or a single session time? if a sum you need a sessions table.
- is yr test file a fixed structure or a suggestion I can modify?

thank you, lesouef:)

> is the report relevant of the person or the project?
No

> is the amount of time per project a sum or a single session time?
what isa single session time?

>  is yr test file a fixed structure or a suggestion I can modify?
suggestion you can modify.

try this then:
http://www.lesouef.net/files/project_mgt_hiro.fp7

thank you, lesouef:)

if i want to add delete button, what should i do?
http://www.angelakello.com/hiro/project_mgt_hiro.fp7

like that!
http://www.lesouef.net/files/project_mgt_hiro-2.fp7
see the little trash... yr button was too big to fit!

plus how do i prevent from adding blank record of "project time management"?

thanks, lesouef:)
you are the best!!!!!!!

thank you, lesouef:)

can you make sammary like this?
http://www.angelakello.com/hiro/Snap16.gif
http://www.angelakello.com/hiro/project_mgt_hiro-2.fp7

plus... can you make every project summary with one button?

your script... "new_line"... what is "Commit Records/Requests"?

if you want to prevent to enter a blank record, you need to get the user to enter data in temp fields in a specific window, check the values, then create or not the new record yourself in a script.

what do you mean by summary like this? put portal lines in a single text field?
summaries are normally done using a dedicated layout where you use sub-summary parts to get a nice report.
my filemaker is now busy building a complex table automatically, and this will take over 2 hours. I'll have a look at this too-morrow.

thank you, lesouef:)

> what do you mean by summary like this? put portal lines in a single text field?
i want a portal show all project time management record by each project...
is it possible?

your script... "new_line"... what is "Commit Records/Requests"?
----------------
this is not always necessary, it depends on how the layout is set; automatic save or not.
it the save mode is automatic, you can remove it; if not, you will get a message to confirm record creation which I don't want in our case, so this command will simulate a record creation manual confirmation. I always do it to avoid a problem if somebody decides to change the layout recording mode later on.

i want a portal show all project time management record by each project...
is it possible?
---------------
yes if you have one table for project, and another one for time management, which I don't remember now, and can't check since my script is still running!!
I'll let you know later one

from yr example file, it's all wrong, you don't need a table for summaries!
you either put a portal to "project time management" table in the "project" table layout or
create a sub-summary part in the layout related to the "project time management" table.
the decision must be made depending on the fact you want to see it on screen (1st solution) or only print/preview it (2nd solution)

thank you, lesouef:)

could you please show me an example? i don't know how to create sub-summary part.

In the project layout, I made the portal to see time spent on each project
then I made an extra layout projectsummary to show a sub-summary part, this must be used with the "printed_summary" script to see the effect.
(I have renamed one table to be able to read field names in dialogs windows! I was born under DOS, so I like short names)

forgot the file
http://www.lesouef.net/files/project_mgt_hiro-2.fp7
(now available yet, my ftp server is down at the moment)

thank you, lesouef:)

i can't see subsummary... where should i go...

what do you think of this?
http://www.angelakello.com/hiro/project_mgt_hiro-4.fp7

do you know how to find record between start and end date?

http://www.angelakello.com/hiro/Snap3.gif

file is available now... reload it.

start... end date:
use find:
start > [date] and end < [date]

thank you, lesouef:)

is there any way to use add button with IWP?

When i use them with browser, i doesn't work.

what does sub-summary field do?

http://www.angelakello.com/hiro/Snap15.gif

shouldn't i use portal if i want to input PTmanagement?

is there any way to use add button with IWP?
-----------
remove the "commit records" command in the new_line script. it is a non web compatible command

a sub-summary allow to summarize records, sorted according to some of the fields, and display them as a kind a table of contents (hierarchic)
it is used for most reports where you want things to be categorized

shouldn't i use portal if i want to input PTmanagement?
--------
does not matter, you can enter via the portal or not.
enter via the portal avoids to enter the project name since the portal you click in designate the current project.

> remove the "commit records" command in the new_line script. it is a non web compatible command
i did it but still doesn't work... am i doing anything wrong?

thank you, lesouef:)
it does work with filemaker... but when i click add button on iwp... it doesn't create new record...

i did it but still doesn't work... am i doing anything wrong?
----------
no its probably one of the web limits. but there maybe a way to write a script which works. on top it may work but won't refresh the screen. if you check using the regular client, is the new portal row created? probably not...
why don't you create new records in the PTM layout then come back in the project layout where you have a portal?

it can't work, it does not work anymore in the regular version either, you changed the relationship since I wrote the script!

if you go back to project_mgt_hiro.fp7, it used to work, try the web with this one

i guess... "Set Variable" script doesn't work with IWP... I don't know why...
do you know any other way around?

i found out... the problem is... i use fm english version... and host server is japanese version... i need to re-create script in japanese version...

since i'm using fm7 advanced server, i can't use that function... even i'm using fm8 pro for client... is there any way without using "Set variable" function?

should i use global data for setting variable?

could you please change the script fm7 compatible?

thank you, lesouef:)
that works great!