Discussions

Expand all | Collapse all

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

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

    Posted 08-02-2018 00:21
    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">http://www.receita.fazenda.gov.br/pessoajuridica/cnpj/cnpjreva/cnpjreva_solicitacao.asp">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?


  • 2.  RE: url button to open a website and fill in with a value on a field

    Posted 08-02-2018 05:24
    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.