Jump to content

MParker

Members
  • Content Count

    86
  • Joined

  • Last visited

Community Reputation

0 Neutral

About MParker

  • Rank
    member
  • Birthday 06/09/1978

Profile Information

  • Gender
    Male
  1. so, i have a filemaker database that i built for work. i have the database where you can import pictures. but to keep everything 'uniform', i wrote an applescript that will check the file that is being added to see if it is a jpg. if it is, it will rename it, move it to our server drive and import it to filemaker. if it's not a jpg, it will convert the file to jpg using image events, then continue the process with the jpg that was just created. it works like a charm in script editor. but when i add it to filemaker, it works for the firsts time i run the script, but on the second and all following times, i get a -1708 error that image events can't continue launch. if i quit filemaker, then start it back up and run the script again, it will work for the first one, then error out every time after that. little confused. any ideas? ***EDITED 09/15/15: DISREGARD THIS POST. I FOUND THE PROBLEM. IT SEEMS THAT IMAGE EVENT WAS STAYING OPEN WHILE FILEMAKER WAS. HAD TO ADD A 'QUIT' LINE AND NOW IT WORKS PERFECTLY. A MOD OR ADMIN CAN DELETE THIS POST IF YOU WOULD LIKE.
  2. comment, you seem to be the person on this forum that always saves my day. lol. THANK YOU!
  3. ok, so i'm stuck again and figured the experts here would find this to be easy, but it is just not coming to me. so, i'm building a finance tracking database to track my bills for the month and basically, i'll have two tables. one will be the payees table (which will have the payee name, amount due, date due, etc), and one table will be the list view of all the 'transactions' for the month. essentially, at the beginning of the month, i want to click a button that will run a script to fill in all upcoming bills. which works fine...until i got to one that needs to be paid every friday instead of once a month. so, how can i calculate it to know to add a new record with the date of every friday in the month (4, sometimes 5 instances depending on the month). is there an easy way to calculate that? p.s. - if i posted this in the wrong forum, i'm sorry. I wasn't sure where it should go.
  4. perfect! thank you for your help, comment!
  5. that works great, but when i do it, it comes out looking like this: "set afflName to \"123456\"¶tell application \"Google Chrome\"¶delay 1¶ tell application \"Google Chrome\" to set index of window 1 where title contains \"Sample Page\" to 1¶do shell script \"open -a Google\\\ Chrome\"¶ tell active tab of window 1¶ set t to (execute javascript \"document.getElementsByTagName('html')[0].innerHTML\") as text¶ if t contains afflName then¶ repeat while loading is true¶ delay 0.1¶ end repeat¶ set idNumber to text ((offset of afflName in t) - 7) thru ((offset of afflName in t) - 3) of t¶ set strippedNumber to my getNumerals(idNumber)¶ --display alert strippedNumber¶ execute javascript \"document.forms['Form1']['ddlAffiliateList'].value = '\" & strippedNumber & \"'\"¶ else¶ display dialog \"AFFILIATE NOT FOUND\" buttons {\"OK\"}¶ end if¶ end tell¶end tell¶on getNumerals(input)¶ set digits to \"1234567890\"¶ copy input to nonNumbers¶ repeat with thisnumber in digits¶ set AppleScript's text item delimiters to thisnumber¶ set nonNumbers to every text item of nonNumbers as text¶ end repeat¶ try¶ repeat with thischar in nonNumbers¶ set endTest to item 1 of nonNumbers¶ set AppleScript's text item delimiters to endTest¶ set input to every text item of input¶ set nonNumbers to every text item of nonNumbers¶ set AppleScript's text item delimiters to \"\"¶ set input to input as text¶ set nonNumbers to nonNumbers as text¶ end repeat¶ end try¶ return input¶end getNumerals" is there no way to have it show the new lines properly? if i had to go back and edit this later, it would be a nightmare to sift through.
  6. ok, scratch that. it's on the line. i started a new script and just added one line at a time until it errored out and that's the one. so.....hmmmm.... ok, found it. i guess it needed 3 "\" instead of two between Google and Chrome. weird.
  7. i'm about to pull my hair out here. i've got an applescript that works perfectly in the applscript editor, but when i try to add it to filemaker as a calculated value, i get that error. i'm not finding what quote i'm missing. any help would be greatly appreciated. this is the script editor version: and here is the filemaker version: I have to think it's on the "execute javascript \"document.forms['Form1']['ddlAffiliateList'].value = '\" & strippedNumber & \"'\"" & ¶ &" line, but i've tried everything and can't seem to figure it out. please help!
  8. worked like a charm. thank you so much eos! you're a genius. (or i'm just really stupid...either way. lol)
  9. oooohhhh, ok. so, having both windows open might be the issue is what you're saying? let me try that.
  10. i would usually just set the memorized fields as variables, then set fields on the main table with those variables, but there's about 150 fields....so i'm not really wanting to go through all of that.
  11. well, that's the problem. there won't actually be any matching fields. i just need the data from the 'memorized' table to overwrite the data in the main table for just that one record.
  12. I'll try to be as detailed as possible, but here's what i have: I have a paperwork database that is basically allowing me to fill in paperwork that is necessary for my company to start an account. Well, after using this database for a while, I found that I was having to retype a lot of information when the same customer would submit a new app. So, I created a 'template' table that basically stored their information so that when they need a new account, they email me, and I can just click one button and all of their data is imported from the 'memorized' table into the main table. it's been working fine. now i'm starting to notice that we are getting customers who are taking over other accounts, so, i need to figure out a way to have it UPDATE the data from the 'memorized' table to the main table instead of importing a new record and starting from scratch. the problem is that every time i try to do the import (with the update existing records in found set selected), it keeps importing the first record in the memorized table, but not the one that is in the found set. my script (see attached screenshot) pulls up a window with the memorized data, and then has another window with the main data. the script finds the one record (customer) in the memorized table, then selects the other window and omits that single record (showing omitted only). so, now both windows have only one record in each...then it tries to import (or, update i should say)...but it still grabs the first record in the memorized table instead of the one that was just found. what am i doing wrong here???
  13. thank you kris. looks like that might be exactly what i need. got some reading to do.
  14. i 'almost' followed you on that one. haha. what do you mean by a 'delimited array'? i understand what the words mean, i'm just asking how i would go about doing that process? oh, and thank you for the quick reply. also, i can have excel run a macro for the formatting end of it. i'm just trying to figure out how to get the data to work. obviously, getting column headers is default. but getting it to list the names out on the left as headers seems to be stumping me.
  15. oh, i should probably also explain that the names down the left column are from the 'contacts' table, while the events across the top are from an event table. so, two separate tables, but each would be required for their headers.
×
×
  • Create New...

Important Information

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