Jump to content
Sign in to follow this  
Raybaudi

Show only NOT used products

Recommended Posts

Hi all friends

I need to have a value list filtered so that it shows products NOT used into an invoice.

It can be easily made with a plugin like EventScript ( see attached file ), but w/o it ?

Invoice_wo_repeating_line_items.zip

Share this post


Link to post
Share on other sites

Thank you, comment.

Yes, like that ! ;)

I didn't know the extreme power of that script step:

Refresh Window [Flush cached join results]

It's correct to say that that step forces the recalculation of unstored ( because related ) calcs ?

And, do you think that the same effect can be obtained without a script ?

Share this post


Link to post
Share on other sites

I don't know of a way to do this without a script. Without a script, user could move to a new line item without committing the previous one. An uncommitted line item will obviously NOT be included in the list.

This is IN ADDITION to the usual problem of one relationship depending on the results of another. Filemaker does not always see the connection beteen the two, and continues to rely on the cache. That's what the step really does: it forces recalculation of results obtained from a relationship.

Share this post


Link to post
Share on other sites

Hi Daniele,

it seems to be a job for FilterValuesByTest().

FilterValuesByTest ( ¶ & List ( invoiceItemsIDs ) & ¶ ; "value" ; "PatternCount ( text ; ¶ & value & ¶ )" ; 0 )

Edited by Guest

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.