Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Calcuation using a Variable

Featured Replies

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.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.