Skip to main content
Question

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

  • August 2, 2018
  • 0 replies
  • 45 views
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?
    This topic has been closed for replies.

    • anomDiebolt
    • Registered
    • August 2, 2018
    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.

    Terms & ConditionsAccessibility statement