Jump to content

Beto Boton

Members
  • Content Count

    15
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Beto Boton

  • Rank
    member
  • Birthday 04/16/1956

Profile Information

  • Title
    Importer Wholesaler & Retailer
  • Industry
    Importer, Wholesaler, Retailer
  • Gender
    Male
  • Location
    Sunshine Coast, Queensland, Australia
  • Interests
    Curious about everything.

Contact Methods

  • Website URL
    http://botontrading.com

Recent Profile Visitors

996 profile views
  1. Beto Boton

    Timesheets Preferences Module

    THANK YOU Just changing the field to a date type apparently did the magic. CHEERS Beto Boton Australia
  2. Beto Boton

    Timesheets Preferences Module

    It is a TEXT field, it gets formatted via the script I mentioned.
  3. Beto Boton

    Timesheets Preferences Module

    Thank you guys, BUT that is not it. 1- "Always use current system settings" That is set and works fine for other dates in other fields 2- In the "Data Formatting" section, make sure the date option is selected, and choose "Custom" - This option is greyed out on the inspector (field is not locked) The selection of weekly bi-weekly etc is calling script 1218 Set_Pay_Period_Suggestions, and the date after this script is reversed to MM/DD/YYYY beside the field contains DD/MM/YYYY. I was not able to completely understand how it is reverting to an American style date. APPARENTLY this is where it is happening but NO CLUE why SetField [T14_PREFERENCES::Pay_Period_Start_Day_Adj ; Get ( CurrentDate )- Mod ( Get ( CurrentDate ) - T14_PREFERENCES::Pay_Period_Start_Day_Adj ;7 )] Thank you Beto Boton
  4. Hi Jonathan THANK YOU very much for your reply! I believe I'm at a stage of modifications of the original FMSP, I reached a point of no return for a new version.(Modules included etc) I'm a newbie trying to do a Pro's job I know... Let me check with you if I understood correctly. I was able to identify the following scripts that need to be rectified: Documents Script 2337 Contacts Script 2301 Accounts Script 2306 Projects Script 2309 Projects Script 2316, 2317, 2318, 2319 for T16_PROJECTS::contract1,T16_PROJECTS::contract2, T16_PROJECTS::contract3, T16_PROJECTS::contract4 Total of 8 Scripts, any others I missed? There are 2 types of reference for filenames First the ones (2316, 2317, 2318, 2319) like "T16_PROJECTS::contract4" were replaced with GetContainerAttribute ( T16_PROJECTS::contract4 ; "filename" ) // Middle ( GetAsText(T16_PROJECTS::contract4) ; Position ( GetAsText(T16_PROJECTS::contract4) ; "/" ; 1 ; PatternCount ( GetAsText(T16_PROJECTS::contract4) ; "/" ) ) + 1 ; 1000 ) ALL FINE AND WORKING BUT others like on script 2306 where the reference is " T01_ACCOUNTS::account_container ; $repetition" I tried the 2 following options without success GetContainerAttribute ( T01_ACCOUNTS::account_container ; $repetition; "filename") Here I get too many parameters GetContainerAttribute ( (T01_ACCOUNTS::account_container ; $repetition) ; "filename") an here I get too many parentesis ! hahahah I have no idea... HELP How do we refer to an indexed container like T01_ACCOUNTS::account_container ; $repetition ; "filename" Thank you Beto Boton Australia FOUND A POSSIBLE ANSWER, is this correct??? GetContainerAttribute ( T01_ACCOUNTS::account_container[$repetition] ; "filename" )
  5. Further investigation on this matter, reveals an issue with script 2306 Accounts_Container_Export OR the way external storage has been handled (could not find out yet). IF we have set a container to store a reference to the file only, while inserting the PDF file, when you hit open, the file will open properly. BUT. If you set External storage for the container, the folder Datafiles is created the folder account_container also created and 3 files placed inside as follows A copy of the original PDF file A JPG of the original PDF file and A PNG of the original PDF file See attached screenshot. All of the above files will work perfectly if double clicked from the finder opening without a glitch with Preview. But when called to open via button OPEN script 2306 Accounts_Container_Export calls to open $filename "Replacing the contents of a field.png" and not the supposed "Replacing the contents of a field.pdf" and gives the error message like the one above ======== The file "Replacing the contents of a field.PNG" could not be opened. ====== I do understand the creation of thumbnails, their storage etc. BUT I don't understand why the parameter to open the file in the container is passed as PNG not the file PDF, and why preview is not opening the file, if manually it does? This is essential if we receive lots of PDF product catalogs from suppliers. I hope I explained this issue properly and someone had already solved the puzzle and will be able to help with this. I'm sure there is something I'm missing... Cheers Beto Boton
  6. Hello As you will notice, I'm working like mad on starting point to get it customized to taste! I found this issue with DATE FORMATTING. I use "the rest of the planet" date format DD/MM/YYYY which is my system date format. Everything goes OK until now. I tried to change a payment period from monthly period to weekly and the date assigned to start and end period reverted to MM/DD/YYYY. Question: How do I get dates to respect the system date format( DD/MM/YYYY) Here is a screenshot
  7. Hello I'm having issues accessing a file that was added to Digital Docs tab of the Accounts Table. Both methods drag and drop and insert button were tested to add a PDF FILE and give the same issue. Manage Containers indicate on STORAGE the following [database location]/DB_Documents and on THUMBNAILS Generate and store thumb for images checked, Permanent storage checked. When I try to double click inside the container NOTHING HAPPEN and when I hit the button OPEN it shows the message on the image BUT NOTE that the text on the message is referring to a PNG file and not to a PDF Well using debugger and data watch the container has the correct name of the file "ASAKI prices list 2014.08.26.pdf" not PNG If I open the folder DB_Documents/T01_ACCOUNTS/account_container the files(attached) ASAKI prices list 2014.08.26.pdf AND ASAKI prices list 2014.08.26.png (generated- apparently the thumb nail with the internal storage) are present and when double clicked open without any problems in Preview. FINALLY this doesn't happen if the container has an Excel file or a word doc (non preview) Any help will substantially reduce my level of stress ! Cheers Beto Boton Australia ASAKI prices list 2014.08.26.pdf
  8. Beto Boton

    Import issues

    Ok How to import is fine BUT The key issue is the relationships that MUST be present there. If I import 800 products from "Supplier aGoGo" and "Supplier aGoGo" is mentioned on each line of the csv file for each of the 800 products to be imported, HOW, without going one by one of the 800 imported products do I set them to be related to that ACCOUNT. We set up the Account name to be an exact match to the cell "Supplier Name" Once the 800 products are imported, I need to go manually click on the Mag-Glass, select the vendor name "Supplier aGoGo" from the pop up, and ONLY this way the product is linked to the Account. If you ask "Same products from "Supplier aGoGo" the 800 will show up,. Can we AUTOMATE this so the link is done without manual intervention? It is kind of a nightmare to do this for each supplier (Account) and each list of products of this supplier and each contact belonging to this supplier ... I believe I explained it correctly. THANK you experts for any help Beto Boton Australia
  9. Beto Boton

    Phone number formating

    OK I'll leave the question here so some other "novice" like me can find the answer searching for Phone formatting The answer is that a custom function has written the LEFT side of the equation fnPhone (text) = this is located on top of where you write the code ! The solution was to just write text and the result would be: fnPhone (text) = text Like this: //This is a CUSTOM FUNCTION -> Manage -> Custom function -> fnPhone(text) // fnPhone(text) // depending on phone # length, will format accordingly // Timothy Trimble, www.timothytrimble.info // REMOVED FORMATTTING FROM PHONE FIELDS // Let (pnum = Substitute( text; [ " "; "" ]; [ "("; ""]; [ ")"; ""]; [ "-"; ""]; [ "."; ""]; [ "x"; ""] ) ; // Case (Length(pnum) = 7 ; Left(pnum;3) & "-" & Right(pnum;4) ; // Length(pnum) = 10 ; "(" & Left(pnum;3) & ")" & Middle(pnum; 4;3) & "-" & Right(pnum;4) ; // (Length(pnum) = 11 and Left(pnum;1) = "1") ; "1+(" & Middle(pnum;2;3) & ")" & Middle(pnum;5;3) & "-" & Right(pnum;4) ; // (Length(pnum) > 11 and Left(pnum;1) = "1") ; "1+(" & Middle(pnum;2;3) & ")" & Middle(pnum;5;3) & "-" & Middle(pnum;8;4) & " x" & Right(pnum;(Length(pnum)-11)) ; // Length(pnum) > 10; "(" & Left(pnum;3) & ")" & Middle(pnum;4;3) & "-" & Middle(pnum;7;4) & " x" & Right(pnum;(Length(pnum)-10)) ; // pnum ) // ) text ======== wow, what a learning curve... Beto Boton Australia
  10. Hello I'm using FMSP 4.5 on Mac OSX FMP Adv 14.0 I want to get rid of phone formatting, too many countries too many formats and it is inserting x everywhere. What I've done : 1- went to Custom Functions and placed a remar on every line of the function fnPhone(text) and IT DID NOT WORK! Why? What is the correct procedure to just leave the phone as typed with no special formatting? I can find every single phone field and remove the function from there but replacing the function would keep the nice work for a rainy day... Cheers Beto Boton // fnPhone(text) // depending on phone # length, will format accordingly // Timothy Trimble, www.timothytrimble.info // REMOVED FORMATTTIN FROM PHONE FIELDS // Let (pnum = Substitute( text; [ " "; "" ]; [ "("; ""]; [ ")"; ""]; [ "-"; ""]; [ "."; ""]; [ "x"; ""] ) ; // Case (Length(pnum) = 7 ; Left(pnum;3) & "-" & Right(pnum;4) ; // Length(pnum) = 10 ; "(" & Left(pnum;3) & ")" & Middle(pnum; 4;3) & "-" & Right(pnum;4) ; // (Length(pnum) = 11 and Left(pnum;1) = "1") ; "1+(" & Middle(pnum;2;3) & ")" & Middle(pnum;5;3) & "-" & Right(pnum;4) ; // (Length(pnum) > 11 and Left(pnum;1) = "1") ; "1+(" & Middle(pnum;2;3) & ")" & Middle(pnum;5;3) & "-" & Middle(pnum;8;4) & " x" & Right(pnum;(Length(pnum)-11)) ; // Length(pnum) > 10; "(" & Left(pnum;3) & ")" & Middle(pnum;4;3) & "-" & Middle(pnum;7;4) & " x" & Right(pnum;(Length(pnum)-10)) ; // pnum ) // )
  11. Jonathan THANK YOU THANK YOU very much!! I'm getting old (60)..... This is not serious I was looking for a dinosaur and it was a gecko... Cheers Beto Boton
  12. Hi Jonathan Thank you very much for your answer. I do have a script # 0909 EST_Relating_an_Account. I looked at the script and it seems exactly what you mentioned, unfortunately I can't see it been performed when I add an Account (Layout L70). It search the account, insert the selected one and that is it. I'll try to find out why it is performing the fill address part of the script. It performs script #0909A and selects the account fill the field with the selected account and that is it. Cheers Beto Boton
  13. Hello Let's start with the famous introduction "I'm not an expert" but I've been around filemaker for a while. I'm on a Mac FileMaker Pro ADV 14. I would love to know HOW can we populate automatically the Estimates Bill To and Ship To information as soon as we select the "Company" (Account) since this information is already filled in the Account Layout.Can we do exactly the same based on BillTo_Name_First or BillTo_Name_Last ?But WAIT, there is MORE: I have Business as Clients and each Business is an represented by ACCOUNT I have people as clients (CONTACTS) from different places Individuals (Contacts) classified grouped under ACCOUNT "eBay Clients"Individuals (Contacts) classified grouped under ACCOUNT "Website A Clients"Individuals (Contacts) classified grouped under ACCOUNT "Website B Clients"I want to be able to autofill Estimates Bill To and Ship To information based on the CURRENT ACCOUNT (from the field labelled Company) BUT be able to choose different CONTACTS from the same company. I believe this has to be done via a "script trigger" (something I learned from the videos) but I believe it should be 2 scripts that will execute based on whatever I have no idea ! WOW - that was a long one, SORRY about that but ANY HELP will be much appreciated. Cheers Beto Boton Australia
×

Important Information

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