Jump to content

Crinklaw

Members
  • Posts

    13
  • Joined

  • Last visited

Crinklaw's Achievements

Apprentice

Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. Case ( IsEmpty (Description 1 Copy), result1 [ , test2 , result2 , default result]... ) Description 1 Copy is my origional field to enter stuff... i need a result of something like, clear(description 1) or something like that... i need to clear it, delete it, erase it... make it so the copy is where the origional data is entered (layout #1)... and on layout #2 (the history layout) the similar field (descrition 1 copy) is erased, cleared or invisible if no data is entered on layout #1
  2. I don't have a "Rejected" function i tried renaming it and putting in Rejected = case(isempty(Rejected);"";Rejected) but no luck
  3. my filemaker does not have a "rejected" field... it won't let me copy and paste it either. Do you know what version that may be for?
  4. I have two layouts. One is an Incoming Inspection Log, the other is a History of Inspection. Right now it is set up so that you can search for anything from Part Numbers, Vendors, Customers, Date Received... and so on. When we have something come in and it is rejected upon inspection because usually it was assymbled wrong or damaged, we write up an Inspection Report (which is part of the first layout). I want to set up my layout so that when I search for say... a history of a supplier, on that history layout a section will show of how many rejections we had for a paticular day and so on... but if there were no rejections, I don't want an empty field showing up. I want to eliminate empty space. I don't want the field of "description of rejected" material to show up on the history layout if there were no rejections to describe. I need a caliculation field that will clear something, rather than repeat it. Is this possible?
  5. I have two layouts. One is an Incoming Inspection Log, the other is a History of Inspection. Right now it is set up so that you can search for anything from Part Numbers, Vendors, Customers, Date Received... and so on. When we have something come in and it is rejected upon inspection because usually it was assymbled wrong or damaged, we write up an Inspection Report (which is part of the first layout). I want to set up my layout so that when I search for say... a history of a supplier, on that history layout a section will show of how many rejections we had for a paticular day and so on... but if there were no rejections, I don't want an empty field showing up. I want to eliminate empty space. I don't want the field of "description of rejected" material to show up on the history layout if there were no rejections to describe. I need a caliculation field that will clear something, rather than repeat it. Is this possible?
  6. For repeating a field... i know that if you use the Last(field) it will repeat something. But is there a function that will clear a field if nothing is in it? So say on one layout you don't enter something and on another layout that keeps a history of that field, that it doesn't even show up on the layout because it is empty...? There has to be a simple way.
  7. how do you change to real calculation fields ? thanks, you've been very helpful?
  8. What do you do if you have a field that is empty and you don't want it to show up if it is empty. ? don't want the calic field to show up? The formula doesn't have a Clear(text), or Delete(text) Trim(Jeff) & " " & If ( IsEmpty (Jeff), ) , result two )
  9. Lets say my first layout is "layout 1" and my second layout is "layout 2" one field is "Description" that has text in it... and I want the same field to show up on my history layout... what do I need to do? I coudln't get the calic to work.
  10. HELP!!! Whats up everyone. I'm trying to set up a file here. I have two layouts. One is a log to log material into, the other is a history of the logs for different vendors. Anways, I can't seem to figure out how to get certain fields to show up on my history log only if they have text in them. If nothing is entered, I don't want them showing up. How do I do this? Basically I've got a rejection form on the Log for each shipment that is only filled out when we find rejected material. I don't want the form on the history layout if there was no need for it to be filled out. Please help ASAP!! I'm hoping is not complicated where I have to enter in a bunch of formulas into scriptmaker.
×
×
  • Create New...

Important Information

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