Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About ivank

  • Rank
  • Birthday 04/12/1972

Profile Information

  • Gender
  • Location
    Belgrade Serbia
  • Interests
  1. I have no idea whats is the problem there, I ve been trying several times to provide examples in my discussions, no result
  2. I have a table, There is a primarykey InvoiceID, there is a secondaryprimarykey ProductID and there is a field TotalProduct. I want the sum(distinct field totalproduct) for a particular value of InvoiceID. Without the distinct function I arrive at multiple values in various rows of the portal readout - equivalent to simply Sum( field totalproduct) How do I get the Distinct effect in Filemaker?
  3. The problem there is this---I need a cell to calculate two values items out of storage subtracted from items in storage Ok I get the result sum value of all those products in two ways Either list of all values that has been subtracted in a portal, or total value in one cell outside of portal.. If I input a field that is a total value in a portal it produces the total in every cell line in that row(where I was showing items subtracted form product in warehouse) what is needed is each cell in that row to show different totals-do you understand each time we input all the values out of storage. If I have products going out today and product going out tomorrow and next day, those are three different totals in three dates (there is a date field right next to total field so my user can identify which amount was there on which day) , If my whole cell-row shows the first total in cells I got a problem, or next total again in whole cell-row my user cant identify-connect two different dates with two total products. Or god forbid more dates more total which happens when we need to organise data. So how do we design –write a script which would tell the cell row, show me total when needed then go to next cell in a same row and show new total , exit after last. J
  4. seems pretty complicated if i input values in in cellsthat represent quantity out of storage my user want' s to set date field when this transaction was due and also show in a new cell total of those products on that date and then next date, and next etc...
  5. is it possible to set field and related to the sales date, if( todays date) show result sum of related field? thank you
  6. It seems that last time i posted a topic I worked out the assignment , I ll try again, A column on my table is assigned values that represent products leaving the warehouse, a table has two sheets detail one and customs number sheet. I have a field on a Customs sheet should show a result totaling products leaving the warehouse. Instead of totaling the products on customs sheet i get the values for each column row that represent quantity out. what i want is separate total values in a field , each time a total is needed.
  7. Account Admin Password 123 I solved it in the meantime but if you want to play with the file please go ahead it was rather simple at the end LOL
  8. Here is the file Here is the file I was talking about E-Lager Clone Clone.fp7.zip
  9. I made a clone and i want to share it with you but in this reply I cant find the attach file action is there an email, adress that you can share so I can send it via mail, I lost all day playing with this file , and I amg etting streesed , with no solution what II wanted to say is at the begining I have product that are in the warehouse and then another field representing the products leaving the warehouse, which can happen again and again until all the products are out the amount in stock is a result of a calcualtion products in (they are always trhe same ones they are in thats it for example 2800) the product out are entered several times, , for example today 1860, tomorow 100 , day after 2900, amount in stock will always shoe A-B = C instead of A-B=C A-B1=C1 A-B2 =C2 etc how am I doing expalining , yes on the same line
  10. Hello I have a simple relationship between fields in a portal , line item unit Enter (number of items in a warehouse -enter which doesn't change its value once entered, line item unit out of storage Exit (number of items leaving the warehouse) and amount in stock field, which is a calculatuion. line items in minus line items out. The relationship I created using set field on the invoice page Set variable [$$Amount in stock,Value Line Items:Enter-Line Items : Exit] Set Fiedl[Line Items Amount in Stock:Value $$Amount in Stock] Comit records no dialog and Set variable [$$EnterExit,Value Line Items:Enter-Line Items : Exit] Set Fiedl[Line Items Amount in Stock::Value $$EnterExit] Set Fiedl[Related Product Amount in Stock::Value $$EnterExit] Set Fiedl[Related Product Last Enter::Value $$EnterExit] Set Fiedl[Related Product Last Exit::Value $$EnterExit] Comit records no dialog so it shows the values on products page related to the product which is presently handled (exitin the warehouse) Now on the invoice page if I am enterring values in to the exit field more than once untill all my stock is out,the valuse is alwaays substracting from the existing value for products in storage. to be more specific products in product out Amount in stock 300 - 200 = 100 this value never changes it is what I have had - 20 = here value should be 80 = instead is 280 Do I make myself clear?? How do I write the script () to define that each consecutive enter should substract from what was lef in stock not from the beginign value of the products in? thanks
  • Create New...

Important Information

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