# Maker **URL:** https://forum.inductiveautomation.com/c/maker/14.md?page=3 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 4 --- ## [How to trigger SQL Query on request?](https://forum.inductiveautomation.com/t/how-to-trigger-sql-query-on-request/88775)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 8\ **Last updated:** [April 13, 2024, 7:35pm UTC](https://forum.inductiveautomation.com/t/how-to-trigger-sql-query-on-request/88775 "2024-04-13T19:35:58Z")
Hi there, I have a table that gets data from SQL query. But instead of polling evey X second, I want to run the query on reqest. Like when page is loaded, and when i add data using the form below the table. How can this… --- ## [How to subtract tag from tag and store as historian variable](https://forum.inductiveautomation.com/t/how-to-subtract-tag-from-tag-and-store-as-historian-variable/88571)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 2\ **Last updated:** [April 9, 2024, 11:21am UTC](https://forum.inductiveautomation.com/t/how-to-subtract-tag-from-tag-and-store-as-historian-variable/88571 "2024-04-09T11:21:24Z")
Hi there, I'm reading 2 tags, which I want to subtract val\_A from val\_B, and store the result as historian so that I make a graph from the last hour. How can I achieve this? --- ## [How to format date column in SQL table?](https://forum.inductiveautomation.com/t/how-to-format-date-column-in-sql-table/88540)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 8\ **Last updated:** [April 8, 2024, 9:41pm UTC](https://forum.inductiveautomation.com/t/how-to-format-date-column-in-sql-table/88540 "2024-04-08T21:41:05Z")
Hi there, I have an SQL query that summarize energy consumption (and some other values) for each hour for the last 24hours, and displays the value in a table. I want to format the timestamp, to show 21:00-22:00 etc. … --- ## [How to add custom row to SQL dataset?](https://forum.inductiveautomation.com/t/how-to-add-custom-row-to-sql-dataset/88484)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 1\ **Last updated:** [April 7, 2024, 7:31pm UTC](https://forum.inductiveautomation.com/t/how-to-add-custom-row-to-sql-dataset/88484 "2024-04-07T19:31:37Z")
Hi there, I have an SQL query that gived me a dataset as shown below. I want to add new column to this dataset, where the value in each row should be calulated based on values in the other coumns. How can I do this? I… --- ## [Using MQTT Transmitter to Publish Tag Value](https://forum.inductiveautomation.com/t/using-mqtt-transmitter-to-publish-tag-value/39193)
**Author:** [@matthew.tomlinson](https://forum.inductiveautomation.com/u/matthew.tomlinson)\ **Replies:** 9\ **Last updated:** [March 24, 2024, 12:19pm UTC](https://forum.inductiveautomation.com/t/using-mqtt-transmitter-to-publish-tag-value/39193 "2024-03-24T12:19:26Z")
Hello! I'm working on using MQTT with ignition through the Cirrus Link modules. I currently have my Ignition server receiving tag values (from a DHT22 temp/humidity sensor) with no issues. What I'm now working on is try… --- ## [MQTT Transmission Connection Lost Error](https://forum.inductiveautomation.com/t/mqtt-transmission-connection-lost-error/87354)
**Author:** [@Satyam\_Singh](https://forum.inductiveautomation.com/u/Satyam_Singh)\ **Replies:** 3\ **Last updated:** [March 20, 2024, 5:50pm UTC](https://forum.inductiveautomation.com/t/mqtt-transmission-connection-lost-error/87354 "2024-03-20T17:50:22Z")
I am trying to setup Ignition MQTT Transmission to the AWS IoT Endpoint server with certificates and keys. I have followed the instruction as per the below link: \[https://docs.chariot.io/display/CLD80/IBSNOW%3A+AWS+Quic… --- ## [Using maker edition to pull in data from my smart energy meter](https://forum.inductiveautomation.com/t/using-maker-edition-to-pull-in-data-from-my-smart-energy-meter/84860)
**Author:** [@batman01793](https://forum.inductiveautomation.com/u/batman01793)\ **Replies:** 4\ **Last updated:** [March 4, 2024, 2:35pm UTC](https://forum.inductiveautomation.com/t/using-maker-edition-to-pull-in-data-from-my-smart-energy-meter/84860 "2024-03-04T14:35:39Z")
Hi I know my energy provider (octopus energy) has an API so 3rd parties can pull the 30 min live data from the smart meters. I’m interested to see how this could be pulled in to ignition. This information could then be… --- ## [Uses for Maker edition](https://forum.inductiveautomation.com/t/uses-for-maker-edition/86373)
**Author:** [@Ty\_McDiarmid](https://forum.inductiveautomation.com/u/Ty_McDiarmid)\ **Replies:** 7\ **Last updated:** [February 27, 2024, 11:27pm UTC](https://forum.inductiveautomation.com/t/uses-for-maker-edition/86373 "2024-02-27T23:27:37Z")
As most probably know, Maker is the at home version for ignition, for those who didn't know, now you do. My question is what benefits am I actually getting using Maker software opposed to developing my own GUI through py… --- ## [Very basic questions](https://forum.inductiveautomation.com/t/very-basic-questions/86315)
**Author:** [@S1ack](https://forum.inductiveautomation.com/u/S1ack)\ **Replies:** 2\ **Last updated:** [February 24, 2024, 10:51pm UTC](https://forum.inductiveautomation.com/t/very-basic-questions/86315 "2024-02-24T22:51:36Z")
Coming off a work project that was vision based. Working on a home hobby project that is using maker edition. I am struck by how unfamiliar / out of sorts I feel. With basic display components. Label (for static text). … --- ## [UI Framework using neumorphism](https://forum.inductiveautomation.com/t/ui-framework-using-neumorphism/76986)
**Author:** [@twittyfarms](https://forum.inductiveautomation.com/u/twittyfarms)\ **Replies:** 4\ **Last updated:** [February 20, 2024, 2:00am UTC](https://forum.inductiveautomation.com/t/ui-framework-using-neumorphism/76986 "2024-02-20T02:00:53Z")
Hey there, I haven't posted in a few years. Something I am curious about. I have seen this in a few places and didn't know the terminology to discuss it. Its a UI design called neumorphism. I think it would be neat to … --- ## [Calender (Ignition Exchange) not showing in designer](https://forum.inductiveautomation.com/t/calender-ignition-exchange-not-showing-in-designer/85363)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 4\ **Last updated:** [February 7, 2024, 1:51pm UTC](https://forum.inductiveautomation.com/t/calender-ignition-exchange-not-showing-in-designer/85363 "2024-02-07T13:51:01Z")
Hi there, Ive just installed this module: But it is not showing up in the designer after? Shouldn't this show up here? --- ## [Getting started with UDT (MQTT Sparkplug)](https://forum.inductiveautomation.com/t/getting-started-with-udt-mqtt-sparkplug/85199)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 13\ **Last updated:** [February 5, 2024, 9:38pm UTC](https://forum.inductiveautomation.com/t/getting-started-with-udt-mqtt-sparkplug/85199 "2024-02-05T21:38:25Z")
Hi there, Can anyone help me get started using MQTT Sparkplug, and making UDTs in ignition? Where do I start, and what do I need to do? --- ## [Activating Maker](https://forum.inductiveautomation.com/t/activating-maker/84903)
**Author:** [@Matt\_Johnson](https://forum.inductiveautomation.com/u/Matt_Johnson)\ **Replies:** 14\ **Last updated:** [January 29, 2024, 6:42pm UTC](https://forum.inductiveautomation.com/t/activating-maker/84903 "2024-01-29T18:42:39Z")
Good day. When I enter my key and token, I get an error. Activation failed. How can I fix this? --- ## [Importing custom icon SVGs](https://forum.inductiveautomation.com/t/importing-custom-icon-svgs/84839)
**Author:** [@Eric\_Ervin](https://forum.inductiveautomation.com/u/Eric_Ervin)\ **Replies:** 4\ **Last updated:** [January 29, 2024, 3:29am UTC](https://forum.inductiveautomation.com/t/importing-custom-icon-svgs/84839 "2024-01-29T03:29:55Z")
Trying to add custom icons to a perspective project. The example show just dragging the svg file into the icons folder relaunching the designer and it appearing. I get the title of the image there next to the material fo… --- ## [Gateway Startup Failed Raspberry](https://forum.inductiveautomation.com/t/gateway-startup-failed-raspberry/73243)
**Author:** [@ds.progettoautomazio](https://forum.inductiveautomation.com/u/ds.progettoautomazio)\ **Replies:** 18\ **Last updated:** [January 28, 2024, 12:07am UTC](https://forum.inductiveautomation.com/t/gateway-startup-failed-raspberry/73243 "2024-01-28T00:07:12Z")
Good morning, I am in possession of a raspberry pi 4 aarch 64. I have installed ignition (from the command line following tutorials and file "Read me" in the ignition folder) to use the maker edition and I find errors … --- ## [Limit number of rows in a table](https://forum.inductiveautomation.com/t/limit-number-of-rows-in-a-table/84683)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 19\ **Last updated:** [January 26, 2024, 8:22am UTC](https://forum.inductiveautomation.com/t/limit-number-of-rows-in-a-table/84683 "2024-01-26T08:22:22Z")
Hi, I have a MySQL database with 10 rows. I run multiple names queries to make up multiple tables. Not all of there tables need all 10 rows. Is there a way to limit the number of rows displayed in a table either to a fi… --- ## [How to create Dataset from tags?](https://forum.inductiveautomation.com/t/how-to-create-dataset-from-tags/84243)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 37\ **Last updated:** [January 20, 2024, 8:38pm UTC](https://forum.inductiveautomation.com/t/how-to-create-dataset-from-tags/84243 "2024-01-20T20:38:51Z")
Hi there, How can I create a dataset that I can use in a table? I have many tags, that i want to display in a table. --- ## [Expression text entry cursor position wrong](https://forum.inductiveautomation.com/t/expression-text-entry-cursor-position-wrong/84423)
**Author:** [@TRINITY\_FOGARTY](https://forum.inductiveautomation.com/u/TRINITY_FOGARTY)\ **Replies:** 3\ **Last updated:** [January 18, 2024, 10:34pm UTC](https://forum.inductiveautomation.com/t/expression-text-entry-cursor-position-wrong/84423 "2024-01-18T22:34:41Z")
Hi, I am having trouble using the expression text entry boxes in the "expression binding" and expression option under "tag binding". The cursor appears to be 4 character positions to the right of its displayed location … --- ## [Maker Edition Redundancy](https://forum.inductiveautomation.com/t/maker-edition-redundancy/83483)
**Author:** [@Harrison\_Bearden](https://forum.inductiveautomation.com/u/Harrison_Bearden)\ **Replies:** 4\ **Last updated:** [January 17, 2024, 10:05am UTC](https://forum.inductiveautomation.com/t/maker-edition-redundancy/83483 "2024-01-17T10:05:03Z")
Does Maker Edition allow gateway redundancy? I'm getting a "This platform edition does not support redundancy." error when I try to set a gateway as a master. --- ## [Question On Configure Scripts](https://forum.inductiveautomation.com/t/question-on-configure-scripts/84090)
**Author:** [@Eric\_Ervin](https://forum.inductiveautomation.com/u/Eric_Ervin)\ **Replies:** 15\ **Last updated:** [January 15, 2024, 1:50am UTC](https://forum.inductiveautomation.com/t/question-on-configure-scripts/84090 "2024-01-15T01:50:55Z")
I'm sure this has been asked before but it's just not clicking for me. I'm trying to learn some basic scripting. I want to start with something simple such as when an Led display value is 1 or 2 a different Led display m… --- ## [MQTT array, display only 1 value](https://forum.inductiveautomation.com/t/mqtt-array-display-only-1-value/84240)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 18\ **Last updated:** [January 13, 2024, 6:17pm UTC](https://forum.inductiveautomation.com/t/mqtt-array-display-only-1-value/84240 "2024-01-13T18:17:26Z")
Hi there, Using MQTT Engine, im receiving an array of string, which I want to display only one of the string from the array. Im trying to index the array by using "\[2\]", but it displays all the strings in the array anyw… --- ## [Edit SQL content](https://forum.inductiveautomation.com/t/edit-sql-content/82324)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 9\ **Last updated:** [November 24, 2023, 1:14pm UTC](https://forum.inductiveautomation.com/t/edit-sql-content/82324 "2023-11-24T13:14:33Z")
Hello I'm new to SQL but I've manged to get it to work somehow. But it's not too intuitive to change existing content. This is how it works today: To add a new row, enter new BatchNo (SQL key): Then this row is crea… --- ## [Maker edition changing to standard edition during restore](https://forum.inductiveautomation.com/t/maker-edition-changing-to-standard-edition-during-restore/82234)
**Author:** [@james\_Evans](https://forum.inductiveautomation.com/u/james_Evans)\ **Replies:** 0\ **Last updated:** [November 22, 2023, 2:54am UTC](https://forum.inductiveautomation.com/t/maker-edition-changing-to-standard-edition-during-restore/82234 "2023-11-22T02:54:40Z")
I have a maker edition gateway running on a windows PC. I created a Ubuntu Linux VM and installed ignition and selected maker edition. I was able to activate using my newly generated key. when I restored the project fr… --- ## [Self. component paths](https://forum.inductiveautomation.com/t/self-component-paths/81772)
**Author:** [@Guy\_Andrus](https://forum.inductiveautomation.com/u/Guy_Andrus)\ **Replies:** 4\ **Last updated:** [November 10, 2023, 6:35pm UTC](https://forum.inductiveautomation.com/t/self-component-paths/81772 "2023-11-10T18:35:26Z")
I am trying to write a script action on a Perspective component. I am new to this so this may sound clueless: Which of the following are valid examples of component paths? self.sibling self.getChild("Container") slef.… --- ## [Date picker - First day of week](https://forum.inductiveautomation.com/t/date-picker-first-day-of-week/80828)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 3\ **Last updated:** [October 23, 2023, 2:34pm UTC](https://forum.inductiveautomation.com/t/date-picker-first-day-of-week/80828 "2023-10-23T14:34:53Z")
Hello, Ive added a date picker in my project. But when selecting date, sunday is the first day. Is it possible to change it to monday? --- ## [How to format date inside a table](https://forum.inductiveautomation.com/t/how-to-format-date-inside-a-table/80825)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 2\ **Last updated:** [October 23, 2023, 12:12am UTC](https://forum.inductiveautomation.com/t/how-to-format-date-inside-a-table/80825 "2023-10-23T00:12:51Z")
Hi there, I have a table that contain multiple data types. But the date datatypes get formatted like shown below. How can i reformat this to an actual date? In the database its shown like this: --- ## [How to sort data from SQL query](https://forum.inductiveautomation.com/t/how-to-sort-data-from-sql-query/80812)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 3\ **Last updated:** [October 22, 2023, 12:32pm UTC](https://forum.inductiveautomation.com/t/how-to-sort-data-from-sql-query/80812 "2023-10-22T12:32:40Z")
Hi! How can i only output i.e the \[BrewDate\] from this query? --- ## [Create table from SQL data](https://forum.inductiveautomation.com/t/create-table-from-sql-data/80811)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 1\ **Last updated:** [October 21, 2023, 10:55pm UTC](https://forum.inductiveautomation.com/t/create-table-from-sql-data/80811 "2023-10-21T22:55:36Z")
Hi there, Whats the easiest way to create a table in ignition from SQL data? --- ## [Database connection failed](https://forum.inductiveautomation.com/t/database-connection-failed/80810)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 2\ **Last updated:** [October 21, 2023, 9:59pm UTC](https://forum.inductiveautomation.com/t/database-connection-failed/80810 "2023-10-21T21:59:40Z")
Hi there, I have a windows machine which has Microsoft SQL server. I have created a database, which I try to connect to with igntion (running on another machine on same network). I get this message: Cannot create Poola… --- ## [Remove arrow in dropdown, change dropdown length](https://forum.inductiveautomation.com/t/remove-arrow-in-dropdown-change-dropdown-length/80580)
**Author:** [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\ **Replies:** 4\ **Last updated:** [October 17, 2023, 1:27pm UTC](https://forum.inductiveautomation.com/t/remove-arrow-in-dropdown-change-dropdown-length/80580 "2023-10-17T13:27:33Z")
Hi there. Is it possible to remove this icon/arrow, and also change the length of the dropdown? [Previous page](https://forum.inductiveautomation.com/c/maker/14.md?page=2) [Next page](https://forum.inductiveautomation.com/c/maker/14.md?page=4)