Calcuation using a Variable

[j4jason83]

I am working on making a database to keep track of time spent working on a project. I then wanted to add a field to make notes in of different things that I did.

My problem is this. On the layout where I enter in my start and stop times, I want to be able to click a button and have a new window open up with a layout has a spot in there so I can enter in the tasks I did for that job. I have tried many different things and I can't seem to get it to work correctly.

I started using the Time Cards template that came with FileMaker as a starting ground. I made my new layout and I have that working.

Now I am trying to get my script to select the current date that I am entering stuff into, and open up the new window with that record. But I can't seem to get it to work for me.

This is what I have so far. I think I am close, but then again, I might not be.

My Script:

Set Variable[$$Day1; Value:Time Billing::Day1]

Allow User Abort [Off]

Freeze Window

Go to Related Record [From table" "Time Billing"; Using layout: "Pop up Sizing_Time - Tasks" (Time Billing); New Window]

Show/Hide Status Area [Lock; Hide]

Adjust Window [Resize to Fit]

Go to Layout["Time - Tasks Detail - Day1" (Time Billing)]

Go to Record/Request/Page [$$Day1]

Pause/Resume Script [indefinitely]

Close Window [Name:"Tasks Performed"; Current file]

I am not sure if there is a better way to accomplish this as I have to have a layout for each day (7 Layouts). That means I would need more scripts.

I would greatly appreciate any assistance or suggestions on how to do this.