Errors? What Errors? | The Low-Code Campfire #100

In this Plant an App discussion, dated June 2nd, 2023, the participants discussed a variety of topics related to low code development and the Plant an App platform. The main topics of discussion included error trapping, updating pop-up titles, and managing email workflows. Also discussed how to resolve issues with importing XML files into a SQL table and modifying scheduled tasks and workflows to get live updates. Major focus is on parsing XML into JSON, extracting certain content, and processing it as a list. Also, it is discussed on how scheduled tasks in automation, as well as using workflows, can help with updating the table on demand and automate the execution of workflow tasks.

00:18 – Error trapping
00:18 - - - Discussion on using 'on error' feature for handling errors in actions
21:11 - - - How to enable on error section in 'execute actions for each list entry'
22:17 - - - Explaining the usage of 'one item list' in the context on error

05:50 – Setting pop-up titles
05:50 - - - How to set the initial value of pop-up titles
09:45 - - - Global on error feature in upcoming updates

14:09 – Managing email workflows
14:09 - - - Using an email table as a queue system for sending emails
16:02 - - - Sending an email and changing the email status to sent
21:11 - - - The on error section and handling errors in automation jobs
31:27 - - - Issues with automation jobs not running and resolving them
32:44 - - - Discussion about job not sending the email and opening a ticket

33:14 – Importing XML files into SQL table

34:30 - - - Example of transforming XML into JSON and displaying it in a table
35:23 - - - Creating a list from JSON, looping through the list, and inserting into SQL
40:04 - - - Using a server request to get XML information in memory
43:51 - - - Experimenting with extracting different elements in XML and using AJAX
45:51 - - - Setting up a schedule task and time trigger for the action
47:07 - - - Differentiation between using automation and workflow for tasks
48:55 - - - Using workflow as an interactive way to update and execute tasks
50:36 - - - Fetching XML by server request
52:32 - - - Workflow and job executions for updating tables
56:47 - - - Creating an admin page to allow the client to manually update the table

1:00:06 – Problem with loading XML data into a table
1:00:37 - - - Reading XML data directly using nodes
1:01:34 - - - Impact of SQL upgrade on the process
1:02:00 - - - The process of selecting from an XML data type

1:03:02 – Benefits of using a merge statement in SQL
1:03:35 - - - Managing transaction logs
1:04:18 - - - How a merge statement is more efficient for updating data
1:05:01 - - - Using a server request to retrieve the file

1:06:04 – Closing remarks and ending the discussion

Join the low-code community in our weekly gathering. We get together to share techniques, challenges, and experiences in building apps with Plant an App.

Learn more about the fastest way to build powerful web apps - https://www.plantanapp.com/

Why attend?
• Gain a deeper understanding of Plant an App
• Learn from the experiences of others
• Demonstrate the techniques you've developed in your apps
• Bring your challenges and get ideas from the Community and the Support team
• Meet & connect with low-code enthusiasts & great people such as yourself

Webinar Sign-Up: https://us02web.zoom.us/webinar/register/3616210110550/WN_FhoNwnH6R6CjTFUI8zNwGw