• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

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?
0
Hiroyuki Tamura
Asked:
Hiroyuki Tamura
  • 25
  • 17
1 Solution
 
lesouefCommented:
what do you want to add? more hours to an existing line? a new line to the portal?
0
 
Hiroyuki TamuraAuthor 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
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Hiroyuki TamuraAuthor 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 TamuraAuthor 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 TamuraAuthor Commented:
plus how do i prevent from adding blank record of "project time management"?
0
 
Hiroyuki TamuraAuthor Commented:
thanks, lesouef:)
you are the best!!!!!!!
0
 
Hiroyuki TamuraAuthor Commented:
0
 
Hiroyuki TamuraAuthor Commented:
plus... can you make every project summary with one button?
0
 
Hiroyuki TamuraAuthor 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 TamuraAuthor Commented:
thank you, lesouef:)
0
 
Hiroyuki TamuraAuthor 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 TamuraAuthor 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 TamuraAuthor Commented:
thank you, lesouef:)

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

start... end date:
use find:
start > [date] and end < [date]
0
 
Hiroyuki TamuraAuthor 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 TamuraAuthor Commented:
what does sub-summary field do?

http://www.angelakello.com/hiro/Snap15.gif
0
 
Hiroyuki TamuraAuthor 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 TamuraAuthor 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 TamuraAuthor 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 TamuraAuthor 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 TamuraAuthor 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 TamuraAuthor 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 TamuraAuthor Commented:
should i use global data for setting variable?
0
 
Hiroyuki TamuraAuthor Commented:
could you please change the script fm7 compatible?
0
 
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
 
Hiroyuki TamuraAuthor Commented:
thank you, lesouef:)
that works great!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 25
  • 17
Tackle projects and never again get stuck behind a technical roadblock.
Join Now