magic buttons - george courtsunis

27
Magic Buttons George Courtsunis

Upload: intuit

Post on 10-May-2015

3.016 views

Category:

Technology


0 download

DESCRIPTION

Leverage QuickBase's formula urls to automate and extend your applications using javascript.

TRANSCRIPT

Page 1: Magic Buttons - George Courtsunis

Magic ButtonsGeorge Courtsunis

Page 2: Magic Buttons - George Courtsunis

What is a button?

Page 3: Magic Buttons - George Courtsunis

QuickBase?

We don’t have a standard button, however you can use URL fields

Page 4: Magic Buttons - George Courtsunis

You probably use buttons to manipulate data already…

Page 5: Magic Buttons - George Courtsunis

So where do I fit in?

You can make your own buttons and manipulate your own data!

Page 6: Magic Buttons - George Courtsunis

<a></a>URL Field

DB Page

JavaScript SDK

QuickBase

Page 7: Magic Buttons - George Courtsunis

The Process

− Create Button

- URL Field

- <a href=“DBPAGE”></a>

− Create DB Page

- html/javascript

- integrate QB javascript SDK- [http://quickbase.com/js/QuickBaseClient.js]

− Link them together

- point field/link to DB Page

Page 8: Magic Buttons - George Courtsunis

LET’S LOOK AT A QUICKBASE EXAMPLE

Page 9: Magic Buttons - George Courtsunis
Page 10: Magic Buttons - George Courtsunis

We can turn a formula URL Field into a button

Page 11: Magic Buttons - George Courtsunis

What’s the formula you say?

Page 12: Magic Buttons - George Courtsunis

What do you think this does?

Page 13: Magic Buttons - George Courtsunis
Page 14: Magic Buttons - George Courtsunis

This is our JavaScript hook

Using this formula, we can use JavaScript to manipulate data

Page 15: Magic Buttons - George Courtsunis

We have a hook and some data…

…what’s next?

Page 16: Magic Buttons - George Courtsunis

− In order to manipulate data, use whatever SDK is easiest for you

− Must be accessible through http

− My examples will pertain to the javascript SDK

Page 17: Magic Buttons - George Courtsunis

DB Pages can store HTML

Page 18: Magic Buttons - George Courtsunis

Let’s look at our wizard copyParentChildren.html

Page 19: Magic Buttons - George Courtsunis
Page 20: Magic Buttons - George Courtsunis
Page 21: Magic Buttons - George Courtsunis
Page 22: Magic Buttons - George Courtsunis
Page 23: Magic Buttons - George Courtsunis

HERE’S ANOTHER EXAMPLE

Page 24: Magic Buttons - George Courtsunis
Page 25: Magic Buttons - George Courtsunis
Page 26: Magic Buttons - George Courtsunis
Page 27: Magic Buttons - George Courtsunis

− You have complex business problems

− You can manipulate QuickBase data through our SDKs

− Buttons and DB Pages make QuickBase data manipulation easy