Jump to content

jim.weeda

Members
  • Content Count

    14
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jim.weeda

  • Rank
    newbie
  • Birthday 11/07/1976

Profile Information

  • Gender
    Not Telling
  1. FileMaker Noob here. I need to create a customer call list from a couple tables in my filemaker db. I have my main customer information table which has all land owners and tenants in it. The way our customer billing system is set up, a piece of property has a location number but can have two different accounts tied to it. So, my table includes that location number, but can have 2 records under with that same number. I have another table that I create records in from a .csv file that is exported from another system in the company. It exports that location number. I import that .csv into my database and link my two tables with that location number. What i want to do is create a list that has the customer name and phone number based on the location numbers that i import. I can't figure out after several hours of dinking around how to create that list. So, lets say i have a location number of 00015. There is a land owner and a tenant listed under that location number in my main table. When I import my .csv file, its only going to have 00015 listed one time. I need my new list to pull both records so that when I export, I have everyones name/phone from that single location number I imported. Thanks in advance!
  2. I'm not completely familiar with Filemaker Go and I can't find anything in the program that gives me this answer or ability. What I need to do is get rid of old servers listed that no longer host files, and also clear the list of files that were recently opened. What happened is we have been implementing a domain controller and a new file server and our FM Server got moved twice and so I show my files being listed on 3 servers now. If I could clear those lists, then I would only show the servers that actually host and only show those files on one server. Thanks!
  3. reichwald114, Thank you so very much! I never thought of it validation as being an error when it found a problem. I turned Error Capture off and voila...it works! =) Thanks for shooting ideas at me!
  4. Well, the "lose their place" comment is just a reference to the illiteracy of the people that will be using it. That is in by no means a bash on them, its just a fact that most of them are not good with computers, and I don't want to have to make them search through a screen full of records just to see which one they have selected. FileMaker does a bad job of highlighting records in my opinion. It shows a tiny little black line on the left side of the first field in the record. Not very useful unless you know what you're looking for. As far as validating that field, what are my other options? That's what I'm trying to figure out. With the dialogue box entry option, it seems that it just fills the info into the fields and it does nothing else as far as validating or anything like that until you click out of the record, which then commits the record, which then validates that field and throws up the error if it is in fact a duplicate.
  5. Well, I'm sure it isn't because I have my unique field set that on commit, it checks to make sure that is a unique value and then it tells me if it isn't. Also, when I set up the field properties to run a script trigger when i leave that field and go to the next it works then too, but when I activate this Custom Dialog box, then it stops working until I actually click out of the record, and then it commits and pops up the duplicate notification. Also, it doesn't do the sort until I click out of the record either, so its like its not finishing that script. But I'm not sure what to look for to fix it or if there is another command in that script that I need to set up to make it work properly.
  6. I have a database set up to log Disconnected Accounts (I work for an electric coop). I'm trying to make it fool proof for my users as most of them are not very computer savvy! I have a New Record button running the following script: Set Error Capture [On] New Record/Request Show Custom Dialog [blah blah] If [Get (LastMessageChoice) = 2] Delete Records/Requests [] End If Commit Records/Requests [] Perform Script ["Sort Records"] My custom dialog box works fine. It pops up with the 3 fields that I want entered and if I hit cancel, it deletes that record or if I hit OK, it enters the record with the correct information. The problem I'm having is that one of my fields is a unique value to keep duplicates at bay, but it won't actually commit the record until i leave the record on the layout instead of in the script. Surely I'm missing something little here. The main reason I want the dialog box is that I don't want my users "losing their place" in the database when they enter a new record. But I also don't want them to have to click out of the record to get it to commit and then they find out they have a duplicate. Does this make sense? Thanks in advance! I'm a novice so I need details! :B
  7. Excellent. I think I was actually figuring that out and remembering that, but I guess sometimes it helps to type it out and then that helps my brain to start thinking in the right direction again. Much appreciated!!
  8. I am utilizing the FM Logins. I have that all set up and working. I also have the sharing thing figured out. I just want an option at the login prompt to allow them to click a "Read Me" file. Maybe it would be better for me to design just a separate layout that has a container field with the Read Me and then some buttons to let them go where they need? Then this would be the first screen they see after they log in?
  9. Howdy. I'm a newbie when it comes to FileMaker developing. I do know enough to build myself some simple and useful databases that I know how to run, but I struggle in making them more usable for other people in the office. What I have is a simple database that allows several of us in the office to add customer accounts that are disconnected. (I work for an electric company) I have it set up to add, edit or delete records and then if the record is in there, they can check a box that it is reconnected and then later, i can go in and run a script to remove all connected accounts. What I would like to do is add a "screen" when they open the file that allows them to log in with their user name and password, but also to have a container field that has a "Read Me" file that they can open right from there. I have no idea how to do this. I'm assuming it would be a layout option, but i don't know how to get the login stuff on it plus the container field, plus not having it as a full screen view either. Does this make sense? Any suggestions? Remember, I'm a newb. I'll need it clarified and dumbed down! :B
  10. Excellent! I was making this way to complicated! I did an Omit Records with KWH criteria set to * and it gave me all the records that didn't have my KWH readings. I added a constrain found set and set it to search only that book and voila, I have my list specific to the book and no reads! Thanks for your help!
  11. Ok, I guess when I start typing this stuff, my mind frees up a little and I start thinking clearly again. I figured out my problem. The ones that don't have a reading don't have a record in the other table, therefore there is no way for it to search. I think what I need to do is load all possible meters into that table, and then just do an update script to load the readings in and then I can do a search for the blank fields because the record will be there. Thanks for helping me get the wheels turning.
  12. What you have detailed is exactly what I tried. I try the basic search and I get the little box that says, No records match this criteria. Something I just thought of...what if those fields show nothing, but had a space(s) in them? Would that disqualify them as blank fields? They are numbers stored in a text field because when I import them as numbers, they are all messed up. Also, I just tried this and i'm editing this reply. In the view that I posted in my image, I can click on any field with something in it and edit that field, but when I try to click on a blank field, I can't add anything or even get a cursor. It's like its not even there. Thanks.
  13. I am creating a database that uploads our automated meter readings and then I want to display on a layout all of the accounts that the reading did not come through on. On my attached image, I show a field labeled KWH. This is the meter reading. I'm trying to build a script that searches for all records that are in the book BB1 and where the KWH field is blank. The KWH field is a record from a related table. Anytime I put the find in for the KWH field and run the script, I get 0 out of 101 records found. I know I'm missing something, but I'm a FileMaker newbie and I'm stuck at this point. I've tried using the = sign and even creating a match record field and finding all those and i still get blanks. Any help? Thank you very much!
×
×
  • Create New...

Important Information

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