LittleMsGinger's post in Run trigger on Password Update was marked as the answer
You can actually create a Trigger to run only if the Password field is updated, given that you only have few fields in the Table. In your criteria, you need to include all the fields except for the password. There should be a Timestamp field as well that will stamp the time upon update. If the timestamp field was changed, it means that there is an update happened for that record. Other fields must be equal from the previous value to the inserted one.
Hope this helps.
LittleMsGinger's post in Pivot Table: Calculated field option grayed out? was marked as the answer
If you select a field in the table, Custom option will not be available. It is present in Totals and Aggregation if you click on the plus button. Also, picker button is not available in Pivot Table.
LittleMsGinger's post in Basic totals? One row pivot table or show only aggregate totals? was marked as the answer
Actually, you can use Pivot table to achieve your desired Report.
You can use Totals and Aggregation under values and add custom formula.
This will be the result
LittleMsGinger's post in Reminder email trigger - stuck was marked as the answer
You can use #inserted in the Select From block instead of the Table (Patients_Encounters_Pre121219). If you use the Table itself, every time the Triggered Action runs, it will send an email to all records where Pending_Info is equal to "Y".
You can refer to this video for more information:
LittleMsGinger's post in On Insert Need to Add 12 Records to Child Table was marked as the answer
As I understand, you want to insert 12 records in AdmissionChecklistItem table upon inserting a record in Admission Table. May I ask if you were inserting 12 identical records?
If yes, there is a workaround for this. You need to create a Dummy table. This will helps with the looping of the trigger.
The trigger on your Admission Table should look like this:
You may import this file to your account and see how it works. Add_12_Records_1_0_2019-Apr-01_2106.zip
Hope this helps.