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
6 Replies
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