Share feedback, ideas and get community help

Updated 12 months ago

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

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
B
M
6 comments
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?
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
To find any existing rows in your spreadsheet:

  1. Insert a Google Sheets block with the "Get data" action
  2. Set the filter to what you'd like to check
  3. Save the result in a variable
  4. Check if that variable is set or empty in a Condition block
  5. If the variable is set, it means the row exist, send a message to the user to select another date and time
  6. If not, proceed
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
As I said, it starts to be too complicated. A typebot can't really be a fully fledge scheduling platform...
Yes i Remember but for me typebot has the Power to do
Add a reply
Sign up and join the conversation on Discord