Forum Discussion

Qrew Cadet

7 years ago

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

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/pessoajuridi...

Quickbase Automations

_anomDiebolt_

Qrew Elite

7 years ago

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.

Forum Discussion

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

Related Content

Find and Replace Field Values

Create a QR to outside Website or App

API Button Help

Jinja If statement equals field value

Formula Url Buttons