Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.8K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
url button to open a website and fill in with a value on a field
Sergio Sergio
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 ...
_anom Diebolt)
08-02-2018 05:24
The appearance of the CAPTCHA may suggest they don't want you to automate around their web form. ...
1.
url button to open a website and fill in with a value on a field
1
Like
Sergio Sergio
Posted 08-02-2018 00:21
Reply
Reply Privately
Options Dropdown
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
0
Like
_anom Diebolt)
Posted 08-02-2018 05:24
Reply
Reply Privately
Options Dropdown
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.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic