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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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