Add dialog to script to email

[Graham Wood]

I have a diabetes database in working on for my partner and would like to be able to tap an action button when the library is opened and it pops up a dialog asking the start and end dates and when ok is selected it puts them in an email to send to the Dr.

Here is a link to the DB

https://mementodb.com/s/ZWV5NCRqq

Thanks in advance 

[David Gilmore]

You can do this using Zapier or using a Memento "rule".

It is a little bit  of a complex procedure, but fortunately Google's AI does a decent job of describing how to do it.

Google "memento database generate email" and observe what the AI says.

Hope this helps!

[Er Mo]

Hallo

Mit einer Regel geht es einfach . Du musst aber zuerst die " Standartdaten " für die E Mail eingeben . So das Memento weiß von Wo die Meil zusenden ist .

Hello
It's easy with a rule. However, you first have to enter the "standard data" for the email. This way, Memento knows where to send the email.

Ernst

[Mmm]

Вариант решения.

Если дата окончания периода не указана в аргументах скрипта действия в библиотеке - она равна текущей дате.

Результат выводится в окно диалог для визуализации решения.

Для отправки сообщения необходимо изменить код.

Если почтовых адресов несколько, можно доработать окно диалог и добавить в него выбор почтового адреса из выпадающего списка.

Шаблон с примером:

https://mementodb.com/t/5774857258401792

понедельник, 11 августа 2025 г. в 21:29:53 UTC+3, ernst...@gmail.com:

[Graham Wood]

Thanks Mmm, can I re enable the email so it sends the email or is there something else to do to send it. Its only going to 1 email

[Mmm]

Нужно изменить комментарии...

Шаблон во вложении.

вторник, 12 августа 2025 г. в 01:32:32 UTC+3, grahamsc...@gmail.com:

[Graham Wood]

Thankyou Mmm perfect as usual. I was using ChatGPT to try and do what you did but it kept getting it wrong every time.

[Amayada]

Hello everyone!  I've been following this thread posted by Graham, and the solution provided by Mmm fits well with what I've been trying to do.  But I think I'm a bit stuck.

As a background, I'm trying to create a database for our cooperative that stores different transactions by our clients.

What I would like to happen is that the email that would be sent will contain the necessary transaction information according to that client and according to the dates chosen.  Presently, the solution sends all the transactions that are saved.  Any help, please?  Also, suggestions on how to improve the library/ies is very much welcome as this is my first foray into an accounting database (maybe fields for sum of deposits, withdrawals, total account of activities of the client, etc.)

Thank you in advance!  

https://mementodb.com/s/PHfM8zTaL

https://mementodb.com/s/28CyYG779

[Amayada]

I think I kinda figured it out ..  I revised Mmm's code a little to filter out the details per ID number, but I need more dummy details to test it out.  But, how do I place the "To:" recipient email automatically?

[Graham Wood]

if its the same script that Im using look in the select dates action script and the very first line is this ( just change it to the address you require)

let mail = 'PUT YOUR EMAIL HERE';

[Amayada]

Hello sir!  Yes!  It was bad for me not to notice that part.  Thanks!

[Amayada]

Oh no!  I thought I had it, but it didn't work.

Here's the borrowed script I'm working with that I need help:

let e = entry();

let mail = e.field("Email address");

let id = e.field("URCC ID number");

//Here's the code provided by Mmm

let start = arg('start date');

let end = arg('end date');

if (moment.isDate(start)) {

   start = moment(start).startOf('d);

if (moment.isDate(end)) {

   end = moment(end).endOf('d');

   } else {

   end = moment().endOf('d');

//Here's where I tried to modify

let entries = lib().entries();

if (entries.length > 0) {

   let uid = e.field('URCC ID Number');

   let transaction = entries.filter(item => item.field('URCC ID Number') === uid && item.id !== e.id);

   let list = transaction;

   let filter = entries.filter(a => moment.isDate(a.field('DateTime')) && moment(a.field('DateTime')).isBetween(start, end, undefined, transaction));

   if (filter.length > 0) {

     if (filter.length > 1) {

       filter = filter.sort((a,b) => moment(a.field('DateTime')).isAfter(b.field('DateTime')));

       }

for (let ee of filter) {

    list.push(addLine(ee));

}

//The rest of the code is for sending an email