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

portal not updating


Recommended Posts

synergy46

 

i am using fm18 adv ....single user app.

i have 2 tables:  stock & stock_transactions.

I have a layout based on stock with a portal based on--[ stock_transactions  it works great.   But in the sock_transaction table I have a calculated field: c_stlt-->

IF (TRANS_DATE+365>=GET (CURRENTDATE);"LONG";"SHORT").  I can see in the data viewer that when I select the 2nd row in the portal and type in a date, fm shows the date from the top row ,  I need to get _c_stlt to work off the date in it's same row.   What am I missing??stock_portal.thumb.png.927e28ec39f5aa572fd7729daca1c327.png 

data viewer.png

Link to post
Share on other sites
AHunter3

In the field definition for a calculation field, there is a button marked "storage options"

Click it.  You should see a checkbox for this option:

"Do not store calculation results -- recalculate when needed"

 

It needs to be checked.

 

Why:  A "Get" function -- such as Get(CurrentDate) -- is not re-evaluated whenever it changes.  Because FileMaker doesn't notice.  So a stored calculation result will store the outcome of Get(CurrentDate) when the record (or field) is first created, and then when the day rolls over it is out of date, it's wrong now.

 

An unstored calc field will come up with a (correct) value on-the-fly when asked to display it -- when "needed".

 

868925625_likethis.jpg.ae84fd40faff4ce9ae28e04c1fa8225e.jpg

Link to post
Share on other sites
synergy46

Idid that.  It is not updating correctly.    As an aside  i am currently trapprd in a recursive script.  Is there a way to break out?  thanks for the thoughts

Link to post
Share on other sites
AHunter3

If your script does not have user abort turned off, hitting the Escape key (Windows) or Command-period (MacOS) will abort a running script.

 

If it does have user abort turned off, that won't work, in which case:

Go to "Tools" and invoke the script debugger.  It will bring any currently running script to a pause, and it has controls that let you kill the script.

 

Although I assume that since you posted this yesterday, you haven't been sitting at your computer watching a recursive script running in perpetuity.  But for next time...   :)

 

Now about your field not updating correctly... can you upload a copy of your file?  The change I recommended should work unless something else is amiss.

Link to post
Share on other sites
AHunter3

Mockup of your db, based on your screen shot.  Field defined as discussed.

Appearance prior to Sept 28 (was originally posted on Saturday Sept 26):

quickie.thumb.jpg.a121226d3777ee0cc04189a45cf37bff.jpg

On Sept 26, I wrote:  Sept 7, 2019 is indeed "SHORT" and Sept 16 is indeed "LONG".  Picking dates closer to exactly one year ago, Sept 25, 2019 is just over a year ago and is "SHORT"; Sept 28, 2019 is just a hair less than a year ago and evaluates as "LONG".

 

Edited Sept 28 to post new screen shot, showing that the value does roll over as it should:

changed.jpg.3ddac4f218810fb65256fee8a92301d7.jpg

 

Are you saying that, in your copy, the Sept 28, 2019 record would continue to say "LONG" even after the end of September 2020?  

 

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.

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.



×
×
  • Create New...

Important Information

Terms of Use