Simple Search Function ( Colin Tree + Airtable Data ) Free AIA Download

techcvr · June 24, 2019, 10:31am

this is a basic search function where the data is stored in the airtable database.

Component Used -

Colin tree extension
Spinner
Textbox
button
Vertical Scroll arrangement
Spreadsheet
Space

Database structure is given below -

App screenshot -

Download AIA - Download AIA
Sample APK - airtableSearch.apk (4.6 MB)
search only those words which i have shown in the database structure images

If you want to add something more in this then you have to do it yourself. Coz its open source. And i am not getting PAID…

vknow360 · June 24, 2019, 10:57am

What do you think about this one:

Nice work…
Keep it up…

minitech24 · June 24, 2019, 3:35pm

Thanks…thanks a lot…i will try it…hope this helpful for me…

vknow360 · June 24, 2019, 3:38pm

I knew it…
You were looking for AIA file.
But be careful while modifying it.Because if you do not use logic it will become useless.

izis27 · July 1, 2019, 9:09am

Hi,

how to do when i select samsung galaxy s10 and it will display all row belong to samsung galaxy s10?
hope you can advise to me. just advise on block.

techcvr · July 1, 2019, 10:01am

blocks are already there… just change the concept… right now its on button click. change it to spinner selection.

izis27 · July 1, 2019, 3:30pm

techcvr,

as i am tested from your apps, when click on list items, it will come with notification of items but how to changed to all row relevant to the list?

techcvr · July 1, 2019, 6:04pm

use the selected item index to fetch data from airtable. i just made a simple search option… you have to make the adjustment according to your need

yanquisalexander · July 1, 2019, 9:35pm

Thank you!!!

It served me a lot !!!

izis27 · July 3, 2019, 3:42pm

techcvr,

search function is working but how do i do when it select a colum it will select all row relevant to him. for example here (screen shoot) i select user “jabir” and i want it select row belong to him such as icnumber, telephone and Alamat. hope you can advice.

airtable

techcvr · July 3, 2019, 6:41pm

you have to store all those columns values in a global variable and then use the index no to fetch the details

izis27 · July 4, 2019, 10:59am

techcvr,

global variable something like below? and index also using that block?
the variable does not work even i add end of url (export?format=csv)

techcvr · July 4, 2019, 2:06pm

no not like this… you have to store the whole cloumn data in a variable by using airtable got column block.

izis27 · July 5, 2019, 3:00am

you have example?

Deepanshu_Arya · July 5, 2019, 3:04am

initialise global variable “AbC” to create empty list

When airtable got column
Set global AbC to get values

techcvr · July 5, 2019, 6:05am

atleast try 1st… i am not here to give you the complete answer. search the forum to know how the airtable component works. there are many apps made with spreadsheet component.

or try @Deepanshu_Arya way. that is the example you need.

izis27 · July 5, 2019, 10:53am

i have search, nothing similar what i want. my background is not apps just try new thing, it might easier for you but for someone else probably an alien when you talk about variable, sql statement and other stuff.
something like this?

techcvr · July 5, 2019, 3:40pm

for starter i’ll suggest you to take some time to study the system, how airtable works. you can download my free projects from my site -
http://techcvr.net/

or search my profile in this forum - Profile - techcvr - Kodular Community

izis27 · July 5, 2019, 3:52pm

well i can only understand the block you using while your tutorial in india language. how can i understand?. Thank you for your advise.

techcvr · July 5, 2019, 5:58pm

im not asking you check my tutorials, go to my site or my kodular profile and check the apps i made using airtable component. i think you will get the concept.