Trigger updating a field

[BoBr Br]

How to use this? Sounds promissing but i can't find any help.

[BoBr Br]

On 

https://wiki.mementodatabase.com/index.php?title=Triggers#Updating_a_field :

Updating a field

TBD

nedelja, 20. marec 2022 ob 09:49:28 UTC+1 je oseba BoBr Br napisala:

[C H]

We speak many languages here and we use online translation, and it usually works pretty good, but it doesn't always handle abbreviations well. I want to promote the practice of spelling out each abbreviation at least once.

For example: "Thanks but done. (TBD)"

I'm just guessing, this is the first time I saw TBD. 

-Craig

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/9bff4e42-0a9f-469f-a7f1-552b9611edban%40googlegroups.com.

[Bill Crews]

This is a section that hasn't been written by any Memento user. Perhaps someone could write it? Contact the Wiki team if so.

So, in the meantime, it's trial & error or email to supp...@MementoDatabase.com -- the same situation we all were in before there was a Wiki.

Here's everything Vasiliy told us about it:  " Added new event for triggers - Updating a field. "

Purely guessing now...

When in the entries list & selecting two or more entries to edit, you get a dropdown list of field names to update. Pick one, and for the selected entries, whatever change you made to the field value will be updated & saved in the library. My guess is that, when this happens, a trigger fires. That leaves questions in my mind...

• Presumably, each selected entry in the list will get its own separate trigger firing, and the script will run for each one. Yes? No? It has to be Yes, but I don't know.

--

[Bill Crews]

Nope. TBD is a pretty well-known term in English that means "To be done". Yet to be done. Yours is a good selection. Actually, I think we all have a lot to learn about autotranslators and idioms, slang, and how they do or don't translate to other languages. I wish we had a mailing list or Google Group or something devoted to this. I'm sure others around the world have done some of that.

When I wrote that, I was the only one actively updating the Wiki, and such comments were notes to myself. That needs to change, and the new wiki (this spring or summer) will do better in this regard.

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/CAHHKQnB9kpR3NdBZ47nLMb79xNfi2g32O2qa6Ej%3DpBmSJXWRHg%40mail.gmail.com.

[Bill Crews]

"selection" should have been "suggestion" -- a good suggestion.

[C H]

Thanks Bill.

A while back I wrote a Memento library for managing a checking account, and the one feature I couldn't make happen was amount suggestions.

This is how I wanted it to work:

User is creating a transaction, enters the name of the payee in that field, then a trigger runs and makes a suggested entry in the transaction amount field, based on the transaction amount in the most recent record for that payee.

It seems like this would be a perfect use case for trigger updating a field. I have stopped using and stopped maintaining that library, and Memento has improved a bit since then. Maybe if I were starting over today I might make a lot more use of Trigger updating a field.

-Craig

[Gilles Mons]

Bonjour,

J'ai créé une table pour tester les " Déclencheur à la mise à jour ".

Vous pourrez voir que ces déclencheurs, fonctionnent uniquement pour les champs dont l'emplacement d'édition peut-être modifié.

Hello,

I created a table to test the "Update Trigger".

You will see that these triggers only work for fields whose edit location can be changed.

Table exemple:

http://libs.mobi/s/c7C4upNBK

Gilles.

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/CAORXpsQ0oNrmkSdWTtH2o3dPw-8xwfM4OdWTXQG99eAbWDCRnA%40mail.gmail.com.

[Bill Crews]

I could easily get carried away with this, because it's been a dream of mine for Memento for years, but I have to tell you, so I'll keep it short if I can.

Memento release 5 (or later) would come out with the following new features:

EnteringField trigger: Executed in EntryEdit card when a user taps on a field ...  or some keyboards have a Tab button to move from field to field. Before the field is filled with its existing value, the script will execute.

The same kind of trigger in the EntryEdit card when exiting a field after the user has put a new value there.

Summary of others: Functions & methods for popping up hidden or dependent fields, a dynamic set() or set() itself will insert values into fields at a field-by-field level. And more.

The result is an EntryEdit card that is alive within the scope of an entry with hints & field values changing or appearing or hiding upon entry & sometimes also upon exit from a field, etc. Maybe a trigger could engage the Checkmark or Save&Close button, ending the entry edit.

I thought this dream was coming true when Vasiliy released Mobile 4.9.2 containing the Updating a field trigger, but it turned out to apply only to editing from the entries list screen, so I'm still looking to the future.

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/CAHHKQnCOGV0CBdEPTi_G0NsyQaszCR9sNNQOkyQrXPDOKi1j4g%40mail.gmail.com.

[Gilles Mons]

Il semblerait que des personnes n'ai pas compris le fonctionnement de la table exemple, j'ai donc ajouté des explications.

It seems that people didn't understand how the example table works, so I added explanations.

Gilles.

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/CAORXpsSAsETFDBw_1AYOkiXFPKHAojTgmW%2Bx9MUUJ8BUafbeAg%40mail.gmail.com.