[FREE] Fruitask Database - A Spreadsheet [Airtable] & Baserow & Google Spreadsheets Alternative

Extensions
, , , ,
#1

Fruitask

Hello everyone, I hope you’re all good. Today I am launching a database extension for Fruitask. It’s a task and data management space for your team or personal projects with incredible built-in apps to integrate. It is built for freelancers, startups and students. This extension helps you to get and set data with fruitask. It has a great community to ask and request anything you want, and more…

Blocks:

Events

blocks (1)
blocks (1)815×1405 48.8 KB

Functions

blocks (2)
blocks (2)258×870 21.1 KB

Properties

blocks (3)
Untitled

Docs

Events

blocks (9)

OnErrorOccurred

On Error Occurred
Params

error | text
errorFrom | text

blocks (7)

OnSetCell

On Set Cell
Params

success | boolean
msg | text

blocks (6)

OnGotCell

On Got Cell
Params

success | boolean
value | text

blocks (5)

OnGotRow

On Got Row
Params

success | boolean
names | list
values | list
row | number

blocks (4)

OnGotAllRows

On Got All Rows
Params

success | boolean
resultContent | any
totalRows | number

blocks (8)
blocks (8)815×85 5.82 KB

OnGotTableInfo

On Got Table Info
Params

success | boolean
tableNameEncrypted | text
createdOn | text
token | text
ownerEmail | text
icons | text
links | text
extra | text
mode | text
rowSet | text

blocks (3)

OnGotCollaborators

On Got Collaborators Info
Params

success | boolean
name | text
email | text
role | text
access | number

blocks (2)

OnGotColumnsInfo

On Got Columns Info
Params

success | boolean
cells | list
types | list
extras | list

blocks (1)

OnDeleteRow

On Delete Row
Params

success | boolean
msg | text
row | number

blocks

OnUpdateRow

On Update Row
Params

success | boolean
msg | text
row | number

blocks (7)

OnCreateRow

On Create Row
Params

success | boolean
msg | text
row | number

blocks (6)

OnCheckedQuota

On Checked Quota
Params

success | boolean
usedLimit | number
maxLimit | number
byPercentage | number

Methods

blocks (5)

SetCell

Set Cell
Params

rowId | number

columnName | text

value | text

blocks (4)

GetCell

Get Cell by Column and Row Number
Params

columnNumber | number

rowNumber | number

blocks (8)

GetRow

Get Row
Params

rowId | number

blocks (3)

GetAllRows

Get All Rows

blocks (2)

GetTableInfo

Get Table Info

blocks (1)

GetCollaborators

Get Collaborators Info

blocks

GetColumnsInfo

Get Columns Info

blocks (7)

DeleteRow

Delete Row
Params

rowId | number

blocks (6)

UpdateRow

Update Row
Params

rowId | number

columnNames | list

values | list

blocks (5)

CreateRow

Create Row
Params

columnNames | list

values | list

blocks (4)

CheckQuota

Check Quota

Properties

blocks (2)

blocks

ApiKey

set api key of your account

Property Type : read-write
Accepts : text

blocks (3)

blocks (1)

Token

set token of workplace table

Property Type : read-write
Accepts : text

How To

Sign In:

  1. Go yo https://www.fruitask.com/
  2. Click Get Started if you don’t have account or Login if you have.
    Untitled
    Untitled1342×591 81.9 KB

Get Api Key:

  1. After Login, click you account photo then choice My Account.
    Untitled
    Untitled1364×613 35.8 KB
  2. Then you will find you api key her :point_down:
    Untitled
    Untitled1356×603 32.5 KB

Get Token:

  1. Go To https://fruitask.com/home/
  2. Then choice you project or create new project
    Untitled
    Untitled1365×616 30.7 KB
  3. Click More
    Untitled
    Untitled1364×518 29.8 KB
  4. You will find your Token her :point_down:
    Untitled
    Untitled1356×595 50 KB

Now Let’s Get Started

This My Database Table which i will test in it

Untitled
Untitled1167×467 21.4 KB 


Name,Info,Age
Ahmed,"My name is Ahmed",10
Mahmoud,"My name is Mahmoud",15
Mohamed,"My name is Mohamed",35
Omar,"My name is Omar",80

Initialize api key and token id

blocks
OR

blocks (1)
blocks (1)705×91 8.59 KB

Set Cell [Update Cell]

blocks
msg = Cell update successfully.

Get Cell

blocks (2)
value = 55

Get All Rows

blocks (3)
resultContent = { "Name": "Ahmed", "Info": "My name is Ahmed", "Age": "10" }, { "Name": "Mahmoud", "Info": "My name is Mahmoud", "Age": "15" }, { "Name": "Mohamed", "Info": "My name is Mohamed", "Age": "35" }, { "Name": "Omar", "Info": "My name is Omar", "Age": "55" }
total Rows= 4

Get Table Info

blocks (4)
blocks (4)815×417 32.2 KB

tableNameEncrypted = USs5OXJBPT0
CreatedOn = August 28, 2023
token = 8uGFhPFcGsZWLHP
owner = *******@gmail.com [I hint it]
icons = bg-zinc-500
links = default
extra = defaul
mode = Private
rowSet = No value found

Get Collaborators

blocks
name = User
email = [email protected]
role = Read-only
access = 1693235388

Get ColumnsInfo

blocks (1)
cell = (Name Info Age)
type = (text longtext text)
extras = ( )

Delete Row

blocks (3)
msg = Row deleted successfully.
row = 4

Update Row

blocks
msg = Row updated successfully.
row = 3

Create Row

blocks (1)
msg = New row successfully added.
row = 4

Check Quota

blocks (2)
usedLimit = 4
maxLimit = 60
byPercentage = 7

Error Occurred

blocks

Fruitask Pricings:

Sponsers

  • Thanks for friutask team for sponser this extesnion by mr @JS.
  • Thanks for @Safetrip for sponser this extesnion.
  • Thanks for @Kelko for sponser this extension.

Donate

AIX:

me.aemo.fruitask.aix (55.8 KB)

Thanks for:

My broo @NotAnAdminUser for help me to write doc and test extension.
And for sponsers

Finally

If you have any question or suggestion post it to her.
If you like my extension don’t forget to hit the like button :+1:.

10 Likes
#2

NOW IT IS FREE :wink:

3 Likes
#3

how i get all row and show in collintree list view

#4

That is simple block to get all rows and display it in list view

My List :point_down:


Name,Info,Age
Ahmed,"My name is Ahmed",10
Mahmoud,"My name is Mahmoud",15
Ali,"My name is Mohamed",23
Hady,"My name is Hady",45

demo block :point_down:

blocks(1)
blocks(1)1106×951 82.2 KB

AIA [Mit Ai2]
Test.aia (59 KB)

demo output

2 Likes
#5

Wow, its finally came to life. Thanks for sharing the extension.

2 Likes
#6

U are welcome :heart:

1 Like