url button to open a website and fill in with a value on a field

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
I have a field "Taxid" in a "prospect table". 
Every time a create a new prospect, I have to:  1) - copy the value of the taxid field, 2) open a website http://www.receita.fazenda.gov.br/pessoajuridica/cnpj/cnpjreva/cnpjreva_solicitacao.asp and 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?
Photo of Sergio

Sergio

  • 492 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,784 Points 20k badge 2x thumb
The appearance of the CAPTCHA may suggest they don't want you to automate around their web form.

But there is still a way to save a step by opening a new window and populating the form with the CNPJ number:

http://www.receita.fazenda.gov.br/pessoajuridica/cnpj/cnpjreva/Cnpjreva_Vstatus.asp
?origem=comprovante
&cnpj=01838723000127

So just make a formula URL field using the [CNPJ] field with all the special characters used.