Is it possible thru API calls to change advanced field options?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Specifically  I would like to take a number of fields and restrict access by roles so that Viewers and Participants have "view" only access.  Thank you in advance for your help!


Photo of Gregory

Gregory

  • 0 Points

Posted 3 years ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
I assume you need to do this for some administrative reason which would be difficult to do manually for perhaps a large number of fields

You can automate this task with CasperJS and PhantomJS using the Off With Their Heads technique as outlined here:

What Is The Off With Their Heads Technique?
https://quickbase-community.intuit.com/questions/1357378
Attached is a CasperJS script which does this for one field with the following command:
DOS>casperjs test2.js

Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=501
See the screenshots attached.
Notes: 
(1) QuickBase appears to be slow for me today so I had to add a 10 second delay on the form submission. I doubt this delay would normally be needed.
(2) It is straightforward to extend this to multiple field and multiple tables. 
(3) Someday everyone will be running QuickBase in headless mode. No kidding!
https://www.youtube.com/watch?v=CtCQHCOls2E
Photo of Gregory

Gregory

  • 0 Points
This is very interesting!  I ran a couple of the samples and updated your script to run on one of my sandbox QuickBase apps.  This will be a handy tool for a number of my projects within and outside of QuickBase.  Thank you!
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
To get fully acquainted with CasperJS I am going to exclusively use QuickBase in headless mode for the next 30 days!  

Seriously ver 1.1.0 was recently released and it has some great features::

http://casperjs.org/

https://media.readthedocs.org/pdf/casperjs/latest/casperjs.pdf
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
FWIW, updated the script to remove the 10 second delay casper.wait(10000, ...) in favor of casper.waitForUrl(...)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
You might be interested in my supplemental answer to my own question:

https://quickbase-community.intuit.com/questions/1357378
I am going to make bank on automating all of my QuickBase work by going headless with CasperJS. My marketing team just created this fantastic new logo for headless QuickBase branding. See screenshot!