Jump to content

Auto entera field based on Date+1 calculation?


This topic is 4318 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello all. I have been trying to find something similar for the past couple of hours and have come up empty handed..

Here is what I am trying to do:

I am working with 1 table 2 layouts.

say the record date is 4/11/2011 - field is "TomoWakeUpCall" (text field) entered as 4:30 am

on 4/12/2011 I would like the feild "WakeUpCall" to auto enter 4:30 am (and viceversa would be excellent) - if I entered it on the 12th instead of the 11th.

I do have a calc field - DayAdd1(date+1) that works but can't put my finger on how to do the same with the WakeUpCall field(s)

I'm basically trying to save myself a few key strokes and page flips.

I do have auto generated s/n for each record but I enter information as I get it so the dates don't always fall in the same order as the s/n's

( i did find some information on GetNthRecord)

Thanks in advance!

Link to comment
Share on other sites

I am only guessing here, since the question is not quite clear. If you define a calculation field (result is Date) =

RecordDate + 1

you can then define two self-join relationships showing the records for tomorrow and for yesterday. Certainly, it is not necessary to enter the same information into 2 places.

field is "TomoWakeUpCall" (text field) entered as 4:30 am

Filemaker has a Time type of field, and it is best to use this for time data.

Link to comment
Share on other sites

This topic is 4318 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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