project time management

do you know how to make this kind of database?

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

Question:
i need to create add button. do you know how to do it?
Hiroyuki TamuraField EngineerAsked:
Who is Participating?
 
lesouefCommented:
Set Variable is supposed to be ok with the web. (no idea when using fm server advanced, only with basic IWP)
You can replace the variable with a global field.

could you please change the script fm7 compatible?
---------
I am not with you anymore, which script is it? fm7? I only use fm6 or 8 now...
0
 
lesouefCommented:
what do you want to add? more hours to an existing line? a new line to the portal?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
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?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
lesouefCommented:
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?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
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.
0
 
lesouefCommented:
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)

if i want to add delete button, what should i do?
http://www.angelakello.com/hiro/project_mgt_hiro.fp7
0
 
lesouefCommented:
like that!
http://www.lesouef.net/files/project_mgt_hiro-2.fp7
see the little trash... yr button was too big to fit!
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
plus how do i prevent from adding blank record of "project time management"?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thanks, lesouef:)
you are the best!!!!!!!
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
plus... can you make every project summary with one button?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
your script... "new_line"... what is "Commit Records/Requests"?
0
 
lesouefCommented:
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.
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
> 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?
0
 
lesouefCommented:
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.
0
 
lesouefCommented:
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
0
 
lesouefCommented:
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)
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)

could you please show me an example? i don't know how to create sub-summary part.
0
 
lesouefCommented:
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)
0
 
lesouefCommented:
forgot the file
http://www.lesouef.net/files/project_mgt_hiro-2.fp7
(now available yet, my ftp server is down at the moment)
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)

i can't see subsummary... where should i go...
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
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?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
0
 
lesouefCommented:
file is available now... reload it.

start... end date:
use find:
start > [date] and end < [date]
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)

is there any way to use add button with IWP?

When i use them with browser, i doesn't work.
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
what does sub-summary field do?

http://www.angelakello.com/hiro/Snap15.gif
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
shouldn't i use portal if i want to input PTmanagement?
0
 
lesouefCommented:
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
0
 
lesouefCommented:
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.
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
> 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?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)
it does work with filemaker... but when i click add button on iwp... it doesn't create new record...
0
 
lesouefCommented:
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?
0
 
lesouefCommented:
it can't work, it does not work anymore in the regular version either, you changed the relationship since I wrote the script!
0
 
lesouefCommented:
if you go back to project_mgt_hiro.fp7, it used to work, try the web with this one
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
i guess... "Set Variable" script doesn't work with IWP... I don't know why...
do you know any other way around?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
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...
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
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?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
should i use global data for setting variable?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
could you please change the script fm7 compatible?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)
that works great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.