- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 13, 2023 02:20 PM
Hello, I currently have a table which calculates the payment to be made to a person according to the number of hours and their category. Sometimes the same person may have several pending payments.
When this happens, is it possible to create a new field with the added information with automation?
The "Folio" field would be used if this is when the new record should be generated. 
That is, if you have a payment of 100, and another of 200, the automation should detect that you have the same folio and generate a new field where the payment is 300.
 In short, I need the values ​​that it shows me when I group them to be generated in a new record.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 14, 2023 03:52 PM
Personally I would try using a roll up field for this instead of an automation. I can't tell from your screenshots if that is a single table or 2 separate tables but if it is a single table then I would create a second table with a linked record field to the first table and then add a roll up field to calculate the payment based on each Folio. If it already is 2 linked tables, then maybe you could just add the roll up field to which ever is appropriate.