Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Weekly order form


Recommended Posts

Every week we need to place an order.

The information for this order is placed in FMP in a spreadsheet type layout that is very specific to the corresponding website

We need to export the orders from only this week and not the week before or any other order thats already been placed

Is this a week-7 problem?

How do I automatically create a new summary of records for each week?

Link to comment
Share on other sites

Exporting records only exports the found set... so do a find for the Orders you want. You can enter a date range in a date field by using ... between dates:


ex. 1/21/2008...1/25/2008 would find records from last business week (assuming a mmddyy date format).

Link to comment
Share on other sites

Here's a calc to make it automatic. The calc assumes you want your weeks to start on Mondays, but it can be adjusted to start on Sundays by using +1 and +7.


Let ( [

today = Get ( CurrentDate ) ;


startweek = today +2 - DayOfWeek (today) ;


endweek = today + 8 - DayOfWeek ( today) ] ;


startweek & "..." & endweek )

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

  • Create New...

Important Information

Terms of Use