# Developers **URL:** https://community.ragic.com/c/developers/6.md [Latest](https://community.ragic.com/latest.md) · [Categories](https://community.ragic.com/categories.md) · [Tags](https://community.ragic.com/tags.md) --- ## [About the Developers category](https://community.ragic.com/t/about-the-developers-category/14)
**Author:** [@jeff\_kuo](https://community.ragic.com/u/jeff_kuo)\ **Replies:** 0
Discussing Ragic HTTP API, custom scripting, custom pages and integrations. --- ## [count the occurrence of a text](https://community.ragic.com/t/count-the-occurrence-of-a-text/19375)
**Author:** [@batoctoy321](https://community.ragic.com/u/batoctoy321)\ **Replies:** 1\ **Last updated:** [March 31, 2026, 8:46am UTC](https://community.ragic.com/t/count-the-occurrence-of-a-text/19375 "2026-03-31T08:46:10Z")
I want to count the occurrence of a text in the column of a subtable. How can I achieve it using formula? If the formula is not capable of it, how about JS Workflow? --- ## [Modify in pre workflow](https://community.ragic.com/t/modify-in-pre-workflow/19150)
**Author:** [@fredrik.carlsson.84](https://community.ragic.com/u/fredrik.carlsson.84)\ **Replies:** 0\ **Last updated:** [February 12, 2026, 7:50pm UTC](https://community.ragic.com/t/modify-in-pre-workflow/19150 "2026-02-12T19:50:41Z")
Hi, When creating a booking, we sometimes create a new address from within the booking sheet. The Address sheet opens in a new window. When saving the address, the system redirects back to the Booking sheet immediatel… --- ## [Improve workflow development efficiency 提升 workflow 開發效率](https://community.ragic.com/t/improve-workflow-development-efficiency-workflow/18981)
**Author:** [@mocliamglink](https://community.ragic.com/u/mocliamglink)\ **Replies:** 0\ **Last updated:** [January 9, 2026, 1:47pm UTC](https://community.ragic.com/t/improve-workflow-development-efficiency-workflow/18981 "2026-01-09T13:47:32Z")
I’ve released a type definition package for Ragic Workflow called types-ragic-workflow. With this package, you can get more complete type hints and better autocompletion in your local development IDE (e.g., VS Code), hel… --- ## [How To Change Value Color Of A Specific Subtable Entry Using JS.](https://community.ragic.com/t/how-to-change-value-color-of-a-specific-subtable-entry-using-js/18472)
**Author:** [@bilal.khan](https://community.ragic.com/u/bilal.khan)\ **Replies:** 1\ **Last updated:** [October 9, 2025, 1:29pm UTC](https://community.ragic.com/t/how-to-change-value-color-of-a-specific-subtable-entry-using-js/18472 "2025-10-09T13:29:02Z")
Hi Ragic community, I’m trying to customize the appearance of a specific subtable entry in my Ragic sheet. I want to change the value color of a particular field in the subtable based on certain conditions. Could someo… --- ## [use NodeRED for Ragic integration](https://community.ragic.com/t/use-nodered-for-ragic-integration/18316)
**Author:** [@mherstus](https://community.ragic.com/u/mherstus)\ **Replies:** 0\ **Last updated:** [September 9, 2025, 10:47am UTC](https://community.ragic.com/t/use-nodered-for-ragic-integration/18316 "2025-09-09T10:47:11Z")
Hi all! I just want to inform that I am succesfully tested NodeRED as Ragic integration tool. NodeRED (www.nodered.org) can be used as open-source and free of charge alternative to n8n. Best regards, MH --- ## [I need a Ragic developer to build a Classic Car Registry for a car club](https://community.ragic.com/t/i-need-a-ragic-developer-to-build-a-classic-car-registry-for-a-car-club/18110)
**Author:** [@cac34](https://community.ragic.com/u/cac34)\ **Replies:** 1\ **Last updated:** [August 5, 2025, 4:27pm UTC](https://community.ragic.com/t/i-need-a-ragic-developer-to-build-a-classic-car-registry-for-a-car-club/18110 "2025-08-05T16:27:09Z")
My name is Chuck Culver and I am webmaster for a Classic car club in central Florida. I don’t really want to learn Ragic so I’m looking for someone to build a classic car registry for my club. I have complete specs writt… --- ## [Using \_ragicId to load a linked value instead of ambiguous displayed value?](https://community.ragic.com/t/using-ragicid-to-load-a-linked-value-instead-of-ambiguous-displayed-value/17956)
**Author:** [@ratscanadadogsports](https://community.ragic.com/u/ratscanadadogsports)\ **Replies:** 1\ **Last updated:** [July 3, 2025, 8:15am UTC](https://community.ragic.com/t/using-ragicid-to-load-a-linked-value-instead-of-ambiguous-displayed-value/17956 "2025-07-03T08:15:12Z")
Hi, I feel like I am asking a very basic question but here it goes. When using the API to create a new record, I would like to use the Ragic ID to specify a linked and loaded value instead of the actual value which coul… --- ## [I want Guidance on Using Ragic for a Custom Workflow](https://community.ragic.com/t/i-want-guidance-on-using-ragic-for-a-custom-workflow/17951)
**Author:** [@c7897009](https://community.ragic.com/u/c7897009)\ **Replies:** 1\ **Last updated:** [July 3, 2025, 8:11am UTC](https://community.ragic.com/t/i-want-guidance-on-using-ragic-for-a-custom-workflow/17951 "2025-07-03T08:11:29Z")
Hey everyone, I am new to Ragic & have been playing around with it for the past couple of weeks. I am a developer trying to build a custom internal workflow for my team & Ragic seemed such as a solid no-code/low-code op… --- ## [does the api support secondary sort?](https://community.ragic.com/t/does-the-api-support-secondary-sort/17933)
**Author:** [@justin3](https://community.ragic.com/u/justin3)\ **Replies:** 0\ **Last updated:** [June 25, 2025, 2:22pm UTC](https://community.ragic.com/t/does-the-api-support-secondary-sort/17933 "2025-06-25T14:22:59Z")
I want to query a set of hardware records and have them sorted by client first and then by hardware id (which is serial: 1, 2, 3…). is this possible with the api? Similar to sql query: ORDER BY sensor.client, sensor.id… --- ## [db query.addFilter(field, 'not equal to', value)](https://community.ragic.com/t/db-query-addfilter-field-not-equal-to-value/17617)
**Author:** [@justin3](https://community.ragic.com/u/justin3)\ **Replies:** 1\ **Last updated:** [May 6, 2025, 5:12am UTC](https://community.ragic.com/t/db-query-addfilter-field-not-equal-to-value/17617 "2025-05-06T05:12:17Z")
Is there a way to add a filter where I can get all the records that a field doesn’t have a value? For example, let’s say I have a table that shows all the requests we’ve received from clients, and I want to query for al… --- ## [db query.addFilter(subtable field id, '=', value)](https://community.ragic.com/t/db-query-addfilter-subtable-field-id-value/17529)
**Author:** [@justin3](https://community.ragic.com/u/justin3)\ **Replies:** 4\ **Last updated:** [April 29, 2025, 4:48pm UTC](https://community.ragic.com/t/db-query-addfilter-subtable-field-id-value/17529 "2025-04-29T16:48:19Z")
is it possible to use addfilter to search for the record that contains a subtable row with the key value? or is the current approach to load all records and use a for loop through subtable records to find what I’m looki… --- ## [API Key Expiration](https://community.ragic.com/t/api-key-expiration/17445)
**Author:** [@justin3](https://community.ragic.com/u/justin3)\ **Replies:** 1\ **Last updated:** [April 7, 2025, 6:23am UTC](https://community.ragic.com/t/api-key-expiration/17445 "2025-04-07T06:23:05Z")
Do API Keys generated from user preferences expire? if so what is their life-span? --- ## [Link and Load vs Post-Workflow](https://community.ragic.com/t/link-and-load-vs-post-workflow/17284)
**Author:** [@justin3](https://community.ragic.com/u/justin3)\ **Replies:** 1\ **Last updated:** [March 11, 2025, 1:56am UTC](https://community.ragic.com/t/link-and-load-vs-post-workflow/17284 "2025-03-11T01:56:28Z")
Where in the record saving process is the link and load called? Is this something that is called simultaneously as the server-side js post workflow is executed creating a race condition or is it called synchronously? Fo… --- ## [API-requesting with multiple field-filters. Is there an AND-operator?](https://community.ragic.com/t/api-requesting-with-multiple-field-filters-is-there-an-and-operator/16792)
**Author:** [@andersmadsen](https://community.ragic.com/u/andersmadsen)\ **Replies:** 6\ **Last updated:** [March 4, 2025, 8:51am UTC](https://community.ragic.com/t/api-requesting-with-multiple-field-filters-is-there-an-and-operator/16792 "2025-03-04T08:51:33Z")
Hi, Is there a way to make an API request using multiple fields for AND filtering? (instead of the OR filtering that you describe in the API documentation). In other words, if I want to create an HTTP-request for all r… --- ## [HTTP POST NO ACTION](https://community.ragic.com/t/http-post-no-action/17186)
**Author:** [@lampic](https://community.ragic.com/u/lampic)\ **Replies:** 1\ **Last updated:** [February 21, 2025, 3:53pm UTC](https://community.ragic.com/t/http-post-no-action/17186 "2025-02-21T15:53:22Z")
Hi , a have tryed this script to print to my web enabled zebra printer , but nothing is sent to my local printer. function print\_this(){ util.postURL(“192.168.1.31”, “^XA^PW400^LL200^FO20,20^A0N,30,30^FDThis is a TEST^… --- ## [Custom JS - error util.post()](https://community.ragic.com/t/custom-js-error-util-post/17146)
**Author:** [@agounin](https://community.ragic.com/u/agounin)\ **Replies:** 1\ **Last updated:** [February 17, 2025, 3:47am UTC](https://community.ragic.com/t/custom-js-error-util-post/17146 "2025-02-17T03:47:44Z")
Hello, I’m using cutoms javascript workflow to request and synchronize with external tools/API. In this case, I’m updating a sheet from netsuite data. I call a custom API that get the data from netsuite and create reco… --- ## [loadLinkAndLoad(entry)](https://community.ragic.com/t/loadlinkandload-entry/17091)
**Author:** [@fredrik.carlsson.84](https://community.ragic.com/u/fredrik.carlsson.84)\ **Replies:** 2\ **Last updated:** [February 5, 2025, 6:57am UTC](https://community.ragic.com/t/loadlinkandload-entry/17091 "2025-02-05T06:57:38Z")
Hi Why is there no Javascript function to Link and load a selected linked field? Or is there? :thinking: --- ## [POST to Comments](https://community.ragic.com/t/post-to-comments/16941)
**Author:** [@atsanon.wad](https://community.ragic.com/u/atsanon.wad)\ **Replies:** 1\ **Last updated:** [January 8, 2025, 2:13am UTC](https://community.ragic.com/t/post-to-comments/16941 "2025-01-08T02:13:28Z")
Hi Ragicians! My old employer (and perhaps future client :sweat\_smile:) wishes to integrate an existing chat client (it’s LINE, and it’s a way the company chooses to interact with its customers) and I thought that comme… --- ## [Ragic Java version of IsContained or Instr](https://community.ragic.com/t/ragic-java-version-of-iscontained-or-instr/16658)
**Author:** [@user1226](https://community.ragic.com/u/user1226)\ **Replies:** 1\ **Last updated:** [November 25, 2024, 4:59pm UTC](https://community.ragic.com/t/ragic-java-version-of-iscontained-or-instr/16658 "2024-11-25T16:59:44Z")
Is there a function in the Javascript Workflow Engine the replicates the Java function IsContained or the VBA function Instr(. I want to see if text A is contained in text B. --- ## [How to get the selected row in Javascript Workflow?](https://community.ragic.com/t/how-to-get-the-selected-row-in-javascript-workflow/16570)
**Author:** [@HumuHumu](https://community.ragic.com/u/HumuHumu)\ **Replies:** 1\ **Last updated:** [November 12, 2024, 2:12am UTC](https://community.ragic.com/t/how-to-get-the-selected-row-in-javascript-workflow/16570 "2024-11-12T02:12:43Z")
I want to use Javascript Workflow to make a button that allows me to get multiple records and create new record based on the selected records, but right now I don’t see any way to get the record selected on the list pag… --- ## [Execute scripts when saving from listing page](https://community.ragic.com/t/execute-scripts-when-saving-from-listing-page/16433)
**Author:** [@justin2](https://community.ragic.com/u/justin2)\ **Replies:** 1\ **Last updated:** [October 18, 2024, 2:50am UTC](https://community.ragic.com/t/execute-scripts-when-saving-from-listing-page/16433 "2024-10-18T02:50:41Z")
I have several scripts that are supposed to execute when saving a record, but those scripts do not run when editing data and saving from the listing page. Is there a way to do this kind of automatic code execution when s… --- ## [Upload file from HTTP Response](https://community.ragic.com/t/upload-file-from-http-response/16281)
**Author:** [@fredrik.carlsson.84](https://community.ragic.com/u/fredrik.carlsson.84)\ **Replies:** 3\ **Last updated:** [September 23, 2024, 6:30am UTC](https://community.ragic.com/t/upload-file-from-http-response/16281 "2024-09-23T06:30:53Z")
Hi, I am using PDF Generator API to create some more advanced PDF files than what is supported by the native PDF generator in Ragic. I make the request via util.getURL() method and everything works. Now I need to take… --- ## [Phone Answering "Tree"](https://community.ragic.com/t/phone-answering-tree/16255)
**Author:** [@user1163](https://community.ragic.com/u/user1163)\ **Replies:** 1\ **Last updated:** [September 18, 2024, 2:23am UTC](https://community.ragic.com/t/phone-answering-tree/16255 "2024-09-18T02:23:54Z")
Is it possible to create a phone answering app in Ragic!? I want to have a three-button phone tree and be able to service several hundred phone numbers. The numbers would NOT inter-operate: they would be totally (exce… --- ## [API endpoints in YAML, OpenAPI, Postman, Swagger format?](https://community.ragic.com/t/api-endpoints-in-yaml-openapi-postman-swagger-format/16257)
**Author:** [@dahlia.ragic](https://community.ragic.com/u/dahlia.ragic)\ **Replies:** 1\ **Last updated:** [September 16, 2024, 12:24am UTC](https://community.ragic.com/t/api-endpoints-in-yaml-openapi-postman-swagger-format/16257 "2024-09-16T00:24:01Z")
Does anyone have all the endpoints for Ragic? --- ## [Update Link and load on subtable sheet on post workflow](https://community.ragic.com/t/update-link-and-load-on-subtable-sheet-on-post-workflow/16200)
**Author:** [@fredrik.carlsson.84](https://community.ragic.com/u/fredrik.carlsson.84)\ **Replies:** 1\ **Last updated:** [September 12, 2024, 6:07am UTC](https://community.ragic.com/t/update-link-and-load-on-subtable-sheet-on-post-workflow/16200 "2024-09-12T06:07:08Z")
Have spent whole afternoon now trying to figure this out. I have a booking sheet where I have a subtable with invoice(s). I want to update link and load on all subtable items when I save. I know there is a button for … --- ## [Update formula in Javascript](https://community.ragic.com/t/update-formula-in-javascript/16218)
**Author:** [@fredrik.carlsson.84](https://community.ragic.com/u/fredrik.carlsson.84)\ **Replies:** 0\ **Last updated:** [September 9, 2024, 8:53pm UTC](https://community.ragic.com/t/update-formula-in-javascript/16218 "2024-09-09T20:53:33Z")
Hi. I have a post workflow from my booking (parent) that creates a new subbooking (subtable of booking) entry. I had to program it myself because I do not want to open up a new sheet which the built in Javascript helpe… --- ## [Record copier function](https://community.ragic.com/t/record-copier-function/16214)
**Author:** [@fredrik.carlsson.84](https://community.ragic.com/u/fredrik.carlsson.84)\ **Replies:** 1\ **Last updated:** [September 9, 2024, 8:29am UTC](https://community.ragic.com/t/record-copier-function/16214 "2024-09-09T08:29:48Z")
Hi Trying to copy field from a booking (parent) to a new record sub booking (child) . Reason why I need it is to make bookings quicker if it is only on subbooking in the booking. However do not get it to work, even if… --- ## [Update field on mail send button](https://community.ragic.com/t/update-field-on-mail-send-button/16139)
**Author:** [@fredrik.carlsson.84](https://community.ragic.com/u/fredrik.carlsson.84)\ **Replies:** 8\ **Last updated:** [September 4, 2024, 6:15am UTC](https://community.ragic.com/t/update-field-on-mail-send-button/16139 "2024-09-04T06:15:44Z")
Hi Have a send mail button, and when I push that one I want to update a status field as sent. In the Javascript workflow is says clearly not to mess with that function If I make a second button with a custom javascrip… --- ## [Email Record Summary Without Approval Status](https://community.ragic.com/t/email-record-summary-without-approval-status/16126)
**Author:** [@lisayuanyuanz](https://community.ragic.com/u/lisayuanyuanz)\ **Replies:** 1\ **Last updated:** [August 30, 2024, 3:51am UTC](https://community.ragic.com/t/email-record-summary-without-approval-status/16126 "2024-08-30T03:51:43Z")
I created an email entry action. I used {{RECORD\_SUMMARY}} to embed the entry in my email body. {{RECORD\_SUMMARY}} shows the approval status. Is there any way to do it without showing the approval status? [Next page](https://community.ragic.com/c/developers/6.md?page=1)