ContributionsMost RecentMost LikesSolutionsurl button to open a website and fill in with a value on a fieldI have a field "Taxid" in a "prospect table". Every time a create a new prospect, I have to: 1) - copy the value of the taxidfield, 2) open a websitehttp://www.receita.fazenda.gov.br/pessoajuridica/cnpj/cnpjreva/cnpjreva_solicitacao.aspand 3) paste the information into the only field of that page, 4) select I am not a ROBOT on recaptcha, 5) copy a result from that page and 6) paste on "CNAE" field in the table "prospect". My question is: How much of that process I could automate with a button?Re: Text Formula URL to open external webpageI would love to know what you did, because i have a similar need Re: pull information from a field in another table from the respective field based on the month of the yearHey Mark. Thank you so much for all the help! I figure what the problem was. It works perfectly! Really appreciate it.Re: NEED TO MANIPULATE CSV FILE PRIOR TO IMPORTI mean that you will have to adapt basic fields like address, phone numbers, language, specially all the errors alerts etc. I am sure you will have a solution for all the barriers my users find.Re: NEED TO MANIPULATE CSV FILE PRIOR TO IMPORTDan, We are a merchant service provider in Brazil, and I have had some of my merchants requesting a CRM solution. One of them really liked what I showed them, and I am sure it would be a great solution. I am very interested to be offering Quickbase as one of my solutions, and I am able to put it to thousands of customers if we can tropicalize it.Re: NEED TO MANIPULATE CSV FILE PRIOR TO IMPORTLooking forward to!Re: NEED TO MANIPULATE CSV FILE PRIOR TO IMPORTCould you share the code or formulas to get the task you mention above accomplished? I also have reports that I receive everyday that need to be worked before importing. Also, would love to automate that. Thanks in advanceRe: pull information from a field in another table from the respective field based on the month of the yearI got one other formula that support was not able to do it. If you have a chance to take a look it would be a blessing! https://community.quickbase.com/quickbase/topics/how-to-create-a-formula-field-that-will-add-all-tra...Re: pull information from a field in another table from the respective field based on the month of the yearGot it!!! Works! Thank you so much!Re: pull information from a field in another table from the respective field based on the month of the yearHi Mark, Yes i did. I does work for records that have the data of transaction on the first day of the month, but its does not work for the other days. Dont I need to add something to the formula to pick up the other days? FirstDayOfMonth([DATE OF TRANSACTION]) It only works for transactions done on the first day, the other days it doesnt work,