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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lesouefCommented:
what do you want to add? more hours to an existing line? a new line to the portal?
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?
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?
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

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

could you please show me an example? i don't know how to create sub-summary part.
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)
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)
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)

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

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

http://www.angelakello.com/hiro/Snap15.gif
Hiroyuki TamuraField EngineerAuthor Commented:
shouldn't i use portal if i want to input PTmanagement?
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
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.
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?
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...
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?
lesouefCommented:
it can't work, it does not work anymore in the regular version either, you changed the relationship since I wrote the script!
lesouefCommented:
if you go back to project_mgt_hiro.fp7, it used to work, try the web with this one
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?
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...
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?
Hiroyuki TamuraField EngineerAuthor Commented:
should i use global data for setting variable?
Hiroyuki TamuraField EngineerAuthor Commented:
could you please change the script fm7 compatible?
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...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, lesouef:)
that works great!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.