RSS

Monthly Archives: September 2018

Airtable – Spreadsheet or Database?

Title

Join Community: http://Community.AppyBuilder.com

Drag, Drop, Snap Blocks, Build app

Airtable is a non-visible component that is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet. Airtable can store information in a spreadsheet that’s visually appealing and easy-to-use, but it’s also powerful enough to act as a database that businesses can use for customer-relationship management (CRM), task management, project planning, and tracking inventory.

AppyBuilder has component and blocks to access and manipulate your Airtable spreadsheets. To start using Airtable:

  1. create an account HERE or simply log into Airtable. Next, create a spreadsheet using “Add a base” and then selecting “Start from scratch”

2. After assigning a name, you’ll be brought to a screen like below. I

  • Item 1 is the name of your spreadsheet (also referred to as base-id).

  • Item 2 is the name of your table (store away this table name)

  • Item 3 is the name of your view (Store away this grid name)

  • Click item 4 (+ sign) to add column.

  • Click on each header (item 5) to either change default column name, or delete column or add a new column.

  • Click on Account (item 6) to retrieve your account API Key (store away this API Key)

Generating API key is by going to your account (item 6 above) and then generating (or viewing) an API Key:

4. Finally, you’ll need to retrieve an id (BaseId) that is a unique id for the selected table. Goto https://airtable.com/api and then select the spreadsheet that was just created. When the page opens, scroll down to “AUTHENTICATION” and on right hand side select “node.js”. Take note of this BaseID.

To manipulate (Add, Read, Update, Delete) data, goto your AppyBuilder project and fro Storage category, select Airtable and drop onto layout:

The properties section of Airtable component will now have the properties shown below. Paste your Airtable API key and Base ID into properties above. Also change the TableName and ViewName to match your Airtable names (use defaults if you haven’t changed them)

In blocks-editor, you can find may blocks to retrieve rows or add, delete, update row / cell data:

There are also event-handler blocks that are associated with the blocks. For example, to retrieve row data, you’ll use Airtable.GetRow block. Once result is retrieved, it will trigger Airtable1.GotRow event-handler:

AppyBuilder contains may other blocks for handling single or multiple rows or columns or even single cell:

Join forum community for tutorials, discussions, technical questions

http://Community.AppyBuilder.com

Website: http://AppyBuilder.com

Share, Like us below ๐Ÿ™‚

 

Advertisements
 
Leave a comment

Posted by on September 22, 2018 in Uncategorized

 

AppyBuilder – Support for Android 4.x

Title

Join Community: http://Community.AppyBuilder.com

Drag, Drop, Snap Blocks, Build app

To set this configurable option, sign into AppyBuilderย and open an existing app or create a new app. Next, in the Component section, select Screen1 (main screen of project):
Now, in the Screen1 properties, you’ll notice drop-down option for setting the minimum API and maximum API versions (Android API version):
Use MinAPI to create backward compatibility all the way back to Android API 14 (Ice Cream Sandwich) to Android API 21 (Lollipop).
Use MaxAPI to meet Google Play’s target API level (26) requirement. Note that Target API 26 requires app user to manually grant permission for sensitive permissions. AppyBuilder includes built-in blocks / feature to ease this process for you and will automatically display relevant information allowing user to grant permissions (such as image below):

 

Join forum community for tutorials, discussions, technical questions

http://Community.AppyBuilder.com

Website: http://AppyBuilder.com

Share, Like us below ๐Ÿ™‚

 

 
1 Comment

Posted by on September 21, 2018 in Uncategorized

 
 
%d bloggers like this: