Jump to content
Sign in to follow this  
klj

Retrieve data from field

Recommended Posts

I appreciate the FM Gods sharing their wisdom to help. Have created a line item list with date fields. Would like to generate scripted reports (monthly, quarterly, yearly) of the line items. Have created calculated fields to get first day and last day of month, qtr and year and a field to combine the dates (1/1/07...1/31/07). My problem is how to get that calculated field into the find window date field. Have tried copy/paste. Doesn't work. Has to be a better way.

Share this post


Link to post
Share on other sites

Try Set Field [], or Insert Calculated Result [].

Share this post


Link to post
Share on other sites

Vaughan, Thanks for the response, however I couldn't get either to work. What I am looking to do is create reports similar to how QuickBooks does.

I have posted the file at: http://homepage.mac.com/WebObjects/FileSharing.woa/wa/default?user=kevinjustice&fpath=2005196%20Walls%20Communications&templatefn=FileSharing1.html

Thanks again

Share this post


Link to post
Share on other sites

Vaughan, Thanks for the response, however I couldn't get either to work. What I am looking to do is create reports similar to how QuickBooks does.

I have posted the file at: http://homepage.mac.com/WebObjects/FileSharing.woa/wa/default?user=kevinjustice&fpath=2005196%20Walls%20Communications&templatefn=FileSharing1.html

Thanks again

Hi Kevin,

In find mode, unstored calcualtions do not evaluate and data fields (excepting global fields) are not available. That's most likely the reason why the approach you've tried is not working.

I suggest that you either construct a script which writes the values to variables (or global fields) while in Browse mode, then transfers the values to the relevant fields once in Find mode (using Set Field[ ] or Insert Calculated Result[ ] as Vaughan suggested).

Or alternatively, if your dates are being calculated from systgem parameters (such as the current date etc), you may be able to simply enter the formulae directly into the specify... dialog for the script commands. Eg:

Insert Calculated Result [YourField; Let([N = Get(CurrentDate); M = Month(N); Y = Year(N)]; Date(M - 1; 1; Y) & ".." & Date(M; 0; Y))]

...will place a text string such as [color:blue]06/1/2007..06/30/2007 into YourField in field mode.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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