how to call data when the date match by airtable?
data will be shown on a label.
send a block diagram of this.
if any free extension available please suggest it.
I want to make a Bengali calendar app.
I store in two row in airtable 1. English date 2. Bengali date.
in the block, when today’s English date match the Bengali date column data call automatically, and show today’s Bengali date.
if any other plan to show today’s Bengali show date , also suggest in reply.
First call both the two column in a global variable and then use compare texts block .
Easily you will achieve what you want
Also go through with this solution
Very simple.
I store in two row in airtable 1. English date (TYPE: DATE), 2. Bengali date(TYPE: SINGLE LINE TEXT)
dora_paz
(Dora)
May 23, 2021, 11:29am
#4
Are you going to use a date picker or a textbox to put date in order to check it with airtable data ?
first i want to show bengali date automatically by english date picker.
its urgent
after that i want implement for custom date by using text box.
Can you share bengali date in text
One way I found is to store in airtable 1. English date (field type date) and 2. Bengali date. I call columns from airtable and save values to global variable then I use the following blocks. Modify code according to your needs and I hope the text I used in my example is a Bengali date cause I do not know the language
I use google sheet
Try this ais Table_BanglaDate.ais (3.4 KB)
Sheet1
23/05/2021,৯ জ্যৈষ্ঠ ১৪২৮
24/05/2021,১০ জ্যৈষ্ঠ ১৪২৮
25/05/2021,১১ জ্যৈষ্ঠ ১৪২৮
26/05/2021,১২ জ্যৈষ্ঠ ১৪২৮
27/05/2021,১৩ জ্যৈষ্ঠ ১৪২৮
28/05/2021,১৪ জ্যৈষ্ঠ ১৪২৮
1 Like
good job but i want to get it automatically change day by day and show bengali date without do any think.
dora_paz
(Dora)
May 23, 2021, 4:46pm
#11
So you want to compare it with phone’s date ?
sibsankar_garai:
date picker.
yes. or online today current date.
dora_paz
(Dora)
May 23, 2021, 4:54pm
#13
Replace Date_Picker1.Instant block with call Clock1.Now block. When screen initialize call data from airtable and then use these blocks
can you send screen for me. please…
dora_paz
(Dora)
May 23, 2021, 5:17pm
#15
All you need is here, just copy the blocks and I’m pretty sure that you know how to call data from airtable.
thank you [sugarlesscreator]
its work.
I’m modified with clock replace with the date picker
Screenshot_20210524-003353|243x500
but when I delete button1 it’s not showing the date. why??
i hide the button. if any solution tell me.
also thank you [dora_paz]
1 Like
sory idont know how to do. try many times. bt not done. plzzz send
dora_paz
(Dora)
May 23, 2021, 7:56pm
#18
Since you already found your solution there is no point asking to send aia. You can use or modify the blocks that I showed you according to your needs
1 Like
Kevinkun
(kevinkun)
May 24, 2021, 9:39pm
#20
https://www.kevinkun.cn/airtable.html
Use this extension to get data with filter.
1 Like