Mario Barretta
TTypebot
•Created by Mario Barretta on 8/5/2024 in #help-and-questions
How to can automatically set a Sheet with get function?
I've a big google sheet with a lot of fiels and i'd like to can found a solution that can give me a sheet block with get function on that to have ALL my columns and not to have to add manually every one.
After i will assign the column to my variable and i know that this have to be a manual job but to have an automation for this will decreas at 50% the work to do in the cases on that we need to show the values form sheet to or bot and i think that a lot of times we need to show all values got from sheet.
Thank you
3 replies
TTypebot
•Created by Mario Barretta on 7/29/2024 in #help-and-questions
Text management
In the past i've asked how to manage date fileds and to change format from one to an other and @Baptiste has created a script for variable bubble with that has been possible:
const inputDate = {{Date}}
const year = inputDate.substr(0, 4); const month = inputDate.substr(4, 2); const day = inputDate.substr(6, 2); const hour = inputDate.substr(9, 2); const minute = inputDate.substr(11, 2); // Create a new Date object const date = new Date(
const year = inputDate.substr(0, 4); const month = inputDate.substr(4, 2); const day = inputDate.substr(6, 2); const hour = inputDate.substr(9, 2); const minute = inputDate.substr(11, 2); // Create a new Date object const date = new Date(
${year}-${month}-${day}T${hour}:${minute}:00);
// Format the date
const formattedDate = date.toLocaleDateString('en-GB', {
day: '2-digit',
month: '2-digit',
year: 'numeric',
});
// Format the time
const formattedTime = date.toLocaleTimeString('en-GB', {
hour: '2-digit',
minute: '2-digit',
hour12: false,
});
// Combine formatted date and time
return ${formattedDate} ${formattedTime};
Make sure to change {{Date}} with your variable name
Now i've an other problem evebr on data management (in this case for text)
In a text bubble i've a variable value (TEXT) for example : "my name is Mario"
being that i need that this value does not have space and must be "my-name-is-Mario" i'm trying to create a script that tranform my variable TEXT in TEXTTRANSFORMED but after some days and tests i'm not able to do and i'me really sorry to not understand how to do it .
I've used all kind of IA but human people are better and so i'me here to ask help so to try to understand how to reach ths result.
Have a nice day3 replies
TTypebot
•Created by Mario Barretta on 7/17/2024 in #help-and-questions
delayed sending mail
Is there a way to manage the sending emails?
I'd like to can take all data by bot flow and to establish a date and hour on that my bubble mail will take in action.
4 replies
TTypebot
•Created by Mario Barretta on 7/13/2024 in #help-and-questions
Variable Link Clickable
After long work 8for me( i've reached a goal to have a variable built with all values that i need but now i need that this variable that has a link become clickable and not appear only how text?
is there a way to can have this result?
if i show the {{variable}} it appear only how Text also if it is a link looklike this : https://site.exetensione/subfolder/function0/function/r/function1?text={{variable1}}&function2={{variable2}}/{{variable3}}&function3{{variable4}}&function4={{variable5}}
3 replies
TTypebot
•Created by Mario Barretta on 7/12/2024 in #help-and-questions
Managing data fields
I'me creating a bot to schedule appointment and the date format requested is ISO (AAAAMMGGTHHMMSSZ)
How can i do to use this format on our date bubble in typebot? that have the format DD/MM/YYYY or YYYY/MM/DD ?
Thank you
5 replies
TTypebot
•Created by Mario Barretta on 7/4/2024 in #help-and-questions
typebot down
Hello everyone,
I know that there are problems with typebot domain but also all my bot with custom domain are down .
No one has same problem?
3 replies
TTypebot
•Created by Mario Barretta on 5/27/2024 in #help-and-questions
Error new version in databse
hello everyone,
This morning i'mne doing some changes on a bot and i've some problems about mail google sheet and stripe that i do not have before.
I see a message pop up that inform me about a new version in database
Can be the problem?
thank you
4 replies
TTypebot
•Created by Mario Barretta on 12/22/2023 in #help-and-questions
More date input Block do not work
13 replies
TTypebot
•Created by Mario Barretta on 12/19/2023 in #help-and-questions
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
7 replies
TTypebot
•Created by Mario Barretta on 12/6/2023 in #help-and-questions
Restaurant Reservation BOT [PARTIALLY SOLVED]
26 replies
TTypebot
•Created by Mario Barretta on 11/15/2023 in #help-and-questions
Variable Link in Text
How can we insert a link (that's related to a variable) on a text bubble?
For example if we have declared a variable (looklike a restaurant's menù link) i'd like to can use my variable how linkon a text bubble.
I know that i can manually insert but if i have a variable and i need to change url i've only to change it and not to follow every bobble on that i've used a link.
14 replies