# \#functions **URL:** https://community.triggre.com/tag/functions/100.md [Latest](https://community.triggre.com/latest.md) · [Categories](https://community.triggre.com/categories.md) · [Tags](https://community.triggre.com/tags.md) --- ## [Using a complex ID from Text and numbers](https://community.triggre.com/t/using-a-complex-id-from-text-and-numbers/958)
**Author:** [@Roland\_Wenzke](https://community.triggre.com/u/Roland_Wenzke)\ **Replies:** 1\ **Last updated:** [April 28, 2026, 6:21am UTC](https://community.triggre.com/t/using-a-complex-id-from-text-and-numbers/958 "2026-04-28T06:21:26Z")
I’d like to use a complex ID for my contracts like in “C\_XYZ\_123456”, with C indicating a contract id, XYZ being a alphanumeric customer id and the number being a simple sequence(could be customer specific or simply a nu… --- ## [Create a complex id from some fixed text combined with a set of random alpha characters](https://community.triggre.com/t/create-a-complex-id-from-some-fixed-text-combined-with-a-set-of-random-alpha-characters/955)
**Author:** [@Roland\_Wenzke](https://community.triggre.com/u/Roland_Wenzke)\ **Replies:** 2\ **Last updated:** [March 18, 2026, 2:49pm UTC](https://community.triggre.com/t/create-a-complex-id-from-some-fixed-text-combined-with-a-set-of-random-alpha-characters/955 "2026-03-18T14:49:52Z")
I am currently working with some BPMN stuff and I am looking for advice on solving something I can’t get done. In BPMN it’s a “convention“ to create the object ids in a way to build them like “Task\_1fr56nO“, actually usi… --- ## [Is there an API to create Automation Flows programmatically (instead of using the Designer)?](https://community.triggre.com/t/is-there-an-api-to-create-automation-flows-programmatically-instead-of-using-the-designer/932)
**Author:** [@Theo\_de\_Groot](https://community.triggre.com/u/Theo_de_Groot)\ **Replies:** 1\ **Last updated:** [November 17, 2025, 1:04pm UTC](https://community.triggre.com/t/is-there-an-api-to-create-automation-flows-programmatically-instead-of-using-the-designer/932 "2025-11-17T13:04:51Z")
Hi everyone, I’m exploring deeper automation with Triggre and I had a question regarding how Automation Flows are created. I understand that when you create an Automation Flow in the Designer with a Web API trigger, Tr… --- ## [Scroll position resets when returning to the table](https://community.triggre.com/t/scroll-position-resets-when-returning-to-the-table/856)
**Author:** [@steijn.winter](https://community.triggre.com/u/steijn.winter)\ **Replies:** 1\ **Last updated:** [January 31, 2025, 7:31am UTC](https://community.triggre.com/t/scroll-position-resets-when-returning-to-the-table/856 "2025-01-31T07:31:14Z")
I’ve noticed that when I scroll down a page and select an item from the table, the scroll position resets to the top when I return to the table. This makes it inconvenient as I have to scroll down again to find my previo… --- ## [98. Automatically calculate the nᵗʰ root of any value with this function](https://community.triggre.com/t/98-automatically-calculate-the-n-root-of-any-value-with-this-function/845)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [December 27, 2024, 9:33am UTC](https://community.triggre.com/t/98-automatically-calculate-the-n-root-of-any-value-with-this-function/845 "2024-12-27T09:33:05Z")
In today’s Triggre Weekend Masterclass, Eddie demonstrates a very useful Triggre function: “nᵗʰ ROOT OF n”. This function lets you calculate the nᵗʰ root of any value, that is, the radical operation or radical extraction… --- ## [94. Functions: RANDOM NUMBER](https://community.triggre.com/t/94-functions-random-number/836)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [November 29, 2024, 4:01pm UTC](https://community.triggre.com/t/94-functions-random-number/836 "2024-11-29T16:01:09Z")
In this Triggre Weekend Masterclass, Eddie shows you how to use the “RANDOM NUMBER” function. This function lets you set custom number ranges and automatically generate random values within them, making it easy to add va… --- ## [92. Functions: SQUARE ROOT OF n](https://community.triggre.com/t/92-functions-square-root-of-n/830)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [November 15, 2024, 8:15am UTC](https://community.triggre.com/t/92-functions-square-root-of-n/830 "2024-11-15T08:15:00Z")
In today’s Triggre Weekend Masterclass, learn how to use the “SQUARE ROOT OF n” function. This function allows you to automatically calculate square roots directly in your business application, so you can easily reduce m… --- ## [90. Functions: A TO THE POWER OF n](https://community.triggre.com/t/90-functions-a-to-the-power-of-n/825)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [November 1, 2024, 8:15am UTC](https://community.triggre.com/t/90-functions-a-to-the-power-of-n/825 "2024-11-01T08:15:00Z")
In today’s Triggre Weekend Masterclass, Eddie demonstrates a very useful Triggre function: “A TO THE POWER OF n”. This function allows you to automatically raise numbers to the power of n, so you can easily integrate adv… --- ## [Support for UUID](https://community.triggre.com/t/support-for-uuid/824)
**Author:** [@sven.brossi](https://community.triggre.com/u/sven.brossi)\ **Replies:** 2\ **Last updated:** [October 26, 2024, 11:02am UTC](https://community.triggre.com/t/support-for-uuid/824 "2024-10-26T11:02:08Z")
Dear all, I want to create a unique document ID. While there are many ways to do this, one of the most efficient would be to use “UUID.” Is there a way to use “UUID” in Triggre already today, or could you imagine provid… --- ## [87. Convert a comma-separated text into a list of data items](https://community.triggre.com/t/87-convert-a-comma-separated-text-into-a-list-of-data-items/817)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [October 11, 2024, 7:39am UTC](https://community.triggre.com/t/87-convert-a-comma-separated-text-into-a-list-of-data-items/817 "2024-10-11T07:39:16Z")
CSV (Comma-Separated Values) files are a common format for storing tabular data in plain text, which is widely used for data storage, transfer, and analysis across different platforms. In this Triggre Weekend Masterclas… --- ## [75. Swap text values with the "REPLACE" function](https://community.triggre.com/t/75-swap-text-values-with-the-replace-function/791)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [July 19, 2024, 7:05am UTC](https://community.triggre.com/t/75-swap-text-values-with-the-replace-function/791 "2024-07-19T07:05:22Z")
In this episode of Triggre Weekend Masterclass, learn how to use the “REPLACE” function to swap text values. Eddie will guide you on how to replace a piece of text (in this example, “Player A”) with a specific value (“Jo… --- ## [74. Convert different data types into text](https://community.triggre.com/t/74-convert-different-data-types-into-text/768)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 7:29am UTC](https://community.triggre.com/t/74-convert-different-data-types-into-text/768 "2024-07-12T07:29:37Z")
In today’s Triggre Weekend Masterclass, Eddie will walk you through the steps to turn numbers, dates, and true/false values into text thanks to the “MAKE A TEXT” function. This feature is useful for easily displaying the… --- ## [72. Filter data using the "REMOVE" function](https://community.triggre.com/t/72-filter-data-using-the-remove-function/726)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [June 28, 2024, 12:57pm UTC](https://community.triggre.com/t/72-filter-data-using-the-remove-function/726 "2024-06-28T12:57:45Z")
In this Triggre Weekend Masterclass, Eddie explains how to filter and manage data efficiently in your application using the “REMOVE” function. This feature helps you to eliminate a specific set of records from another se… --- ## [62. Function "LIST CONTAINS"](https://community.triggre.com/t/62-function-list-contains/691)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [April 19, 2024, 1:22pm UTC](https://community.triggre.com/t/62-function-list-contains/691 "2024-04-19T13:22:56Z")
In today’s Triggre Weekend Masterclass, explore how the “list contains” function streamlines complex data structures like product quotation systems with Eddie’s expert guidance. The “list contains” function in applicatio… --- ## [47. Formulas with brackets](https://community.triggre.com/t/47-formulas-with-brackets/618)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [January 4, 2024, 11:00pm UTC](https://community.triggre.com/t/47-formulas-with-brackets/618 "2024-01-04T23:00:00Z")
Get ready to level up your Triggre game! In today’s “Triggre Weekend Masterclass”, Eddie tackles creating complex rules and formulas using brackets. With Triggre’s powerful rule editor, mastering brackets means transform… --- ## [15. Combine COUNT + SUM](https://community.triggre.com/t/15-combine-count-sum/559)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [May 25, 2023, 10:00pm UTC](https://community.triggre.com/t/15-combine-count-sum/559 "2023-05-25T22:00:00Z")
Functions “COUNT” and “SUM” are key to seamless and accurate inventory and financial management. Join Eddie as he shows you how to add them to your no-code application overview to instantly see your order quantities and … --- ## [14. Functions: COUNT](https://community.triggre.com/t/14-functions-count/558)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [May 18, 2023, 10:00pm UTC](https://community.triggre.com/t/14-functions-count/558 "2023-05-18T22:00:00Z")
In this week’s masterclass, Eddie unveils the handy “COUNT” function, designed to count anything (from ducklings to purchase orders or products sold). Bring order to the chaos and make your business application more effi… --- ## [13. Functions: SUM](https://community.triggre.com/t/13-functions-sum/557)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [May 11, 2023, 10:00pm UTC](https://community.triggre.com/t/13-functions-sum/557 "2023-05-11T22:00:00Z")
The function “SUM” may seem basic at first, but when implemented intelligently in your no-code application, it has the power to transform your entire business process. Join Eddie in this Weekend Triggre Masterclass to le… --- ## [8. Functions: Add X months](https://community.triggre.com/t/8-functions-add-x-months/552)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [April 6, 2023, 10:00pm UTC](https://community.triggre.com/t/8-functions-add-x-months/552 "2023-04-06T22:00:00Z")
Time is always ticking away, and you can’t afford to let a single deadline slip by. That’s why today we’re diving into Triggre’s “Add X Months” built-in function. Master time and easily keep all your deadlines, contracts… --- ## [7. Functions: Combine A with B](https://community.triggre.com/t/7-functions-combine-a-with-b/551)
**Author:** [@Marta](https://community.triggre.com/u/Marta)\ **Replies:** 0\ **Last updated:** [March 30, 2023, 10:00pm UTC](https://community.triggre.com/t/7-functions-combine-a-with-b/551 "2023-03-30T22:00:00Z")
One of Triggre’s most interesting functions is “Combine A with B”, frequently used to generate unique item IDs. In today’s masterclass, Eddie steps into the shoes of a business that generates plenty of quotations and dem…