Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About argwallace

  • Rank

Profile Information

  • Gender
  1. I also found that error code 803 would trigger when trying to import records from a runtime that is open. So in the end I was able to capture this error and proceed accordingly. In other parts of the program, I do use AppleScript and it has worked well thus far. Thanks again!
  2. In my current import scripts, they will run normally but just won't import any data. I'm trying to catch this before it runs the import so I can give a warning. I am not too versed in Applescript though I have used it somewhat. I'd be open to doing that. Any ideas?
  3. Greetings! I have what I hope is a very easy problem to solve. I have a runtime that imports data from another runtime file. Everything works fine as long as the other file is closed. I have had users who have run the import while the other file is open and the script completes but obviously nothing gets imported because the other file is currently locked. Before running the import script, I would like to test to see if the other file is closed. Is there an easy way to do this? Some calculation that I can test against? etc. Any thoughts would be helpful!! Thanks! Stephen
  4. Not sure if it will help in your case, but you can always add a "-" to a radio button list just as you would to a drop down list. On the drop down, it gives you a line, on the radio button, it creates a new column. For what it's worth... Stephen
  5. Hello, Here is what I am wanting to accomplish. I have a contacts database that contains a number of your basic contact fields (i.e. first and last name, addresses, phone numbers, emails, etc.). I want to add a feature into my solution that will attempt to locate duplicates. I would like to present this data in a simple format that could be followed up by the user to determine which record is kept, deleted or perhaps merged together. My question is how to 1) find these records, 2). display all of the possible records and their accompanying duplicate records in a list, 3) provide options fo
  6. Ok, thanks for the feedback everyone. If I don't use SQL and yet have many options that make my relationship more challenging, any options for me. Using list view isn't an option in my scenario.
  7. Hello. I am trying to determine if using an ExecuteSQL function to return results in a portal will be faster than using a Filter Portal option. Here's the need: I have a Report table that is related another table Called Expenses. The expense file has around 10,000+ records and will grow monthly. My design is to display only some of those expenses based on the criteria included in the different reports from the Report table. For example, I may want to drill down on a certain date range, expense values, category of expense, etc. What is the most efficient way to display these results? Si
  8. Question for clarification... What if you are the only user and close the document each time and wait for it to update across your devices, and then do the same from a different device? Would this make any difference to the absolute "NO NO" scenario. Thanks.
  9. Thanks so much on your responses. I will let you know how it goes.
  10. I do have fields for emails and phone numbers. The name strings are also separated into FirstName and LastName. I would like to use a relationship so it could display the possible records for removal, merging, etc.
  11. Hello, I have a contacts solution that may contain similar names but not identical (perhaps). My goal is to locate possible duplicate records. What would be the best way of searching through a list of more than 1000+ contacts and display possible "duplicates" for review? These are contacts that may have been created twice and not actually duplicated. So they all have a unique id. I've seen scripts that use the Levansthein (or something like that) method for comparing similar text. Any thoughts? Thanks and regards! Stephen
  12. Thanks for the feedback. I definitely want to make it simple and performing a find might be easier than SQL statements. I've been drawn to them recently to see how they might work. So that was one of my options. Thanks again!
  13. You are correct in the idea of "dynamic" smart groups as used in other programs. This is an option that I considered so perhaps my terminology may be a misnomer in this case. I was wanting to create a group with records based on a set of criteria, and at this point having the dynamic nature of the group is not required. Let's ignore the use of "smart". What would be the easiest way to accomplish this task?
  14. Hello again. I am trying to avoid creating a new relationship but if that is the best way, then I will go that route. This is my first effort to working with the ExecuteSQL function. The why I am doing this is this: I have a contacts database that users are able organize by the creation of groups. I am attempting to make a smart group feature that will allow the user to select certain criteria (currently this is where I have 6 options, but there may be more). As the user selects one or more of these criteria, the script would locate any matching records using the ExecuteSQL function to gather
  • Create New...

Important Information

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