How to show records, in a data range, from a Google sh...

MMario Barretta

Good morning to all dear fellow Typebot adventurers.
I refer to a previous request of mine, to which @Baptiste egregiously found a solution, (https://discord.com/channels/1155799591220953138/1181878805787320330/1182339090964820128) that allows me to display specific data entered in a google sheet by returning it formatted clearly and legibly as I wanted.

The new request, in addition to the previous one related to point 3 of my request for help :

3) Checking that in case you enter a date and time already occupied for the table number you select an error message is returned

is that you get a result that shows me the data entered not only relative to a specific date but to a range of dates (start date - end date) so that I can see, for example, all the bookings for a week.

I have tried reasoning and running tests but have not, unfortunately, been able to come up with any so I am again asking for help from the more experienced people who will read this new request of mine.

Good day to all

6 comments

BBaptiste

Why isn't it as simple as fetching a row from the Sheet that has the same date and time. Then check if it empty or not?

MMario Barretta

Hi @Baptiste thankyou for reply .
I do not understand what you mean .
Actually not work more also the formatted textual output that you given me in the past.
I have seen that in date input there Is a range settimg

BBaptiste

To find any existing rows in your spreadsheet:

Insert a Google Sheets block with the "Get data" action
Set the filter to what you'd like to check
Save the result in a variable
Check if that variable is set or empty in a Condition block
If the variable is set, it means the row exist, send a message to the user to select another date and time
If not, proceed

MMario Barretta

Thank you for reply .

1) it's ok i've done and it's that i ever do with typebot to get data from a sheet
2) Also this i do filtering based on a specific variable
3) idem
4) i do not know how to do
5) user can not insert every time an other date but it need only to set a range From / To

BBaptiste

As I said, it starts to be too complicated. A typebot can't really be a fully fledge scheduling platform...

MMario Barretta

Yes i Remember but for me typebot has the Power to do

Add a reply

Share feedback, ideas and get community help

How to show records, in a data range, from a Google sheet.