Typebot
Log in

Share feedback, ideas and get community help

Updated last year

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

At a glance

The community member is seeking help to enhance their Typebot application. They previously received a solution from @Baptiste to display specific data from a Google Sheet, and now they have a new request:

1) To check if a date and time entered is already occupied for the selected table number, and return an error message if so.

2) To display the data entered not only for a specific date, but for a range of dates (start date - end date), so they can see all the bookings for a week, for example.

The community members discuss potential solutions, but there is no clear answer provided. Some suggestions include fetching rows from the Sheet based on the date and time, and checking if the row is empty or not. However, the community member indicates they are unable to implement these solutions.

Ultimately, one community member suggests that a Typebot may not be the best tool for a fully-fledged scheduling platform, as it starts to become too complicated. The original community member, however, believes Typebot has the power to handle this type of functionality.

Useful resources
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
B
M
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:

  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
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
Sign up and join the conversation on Discord