mortgage | Simple Mortgage Calculator | Apps library

It would easier to make an intermediate variable to take the daily interest term, so you don't get confused with all the brackets. But the most important problem is that you are overwriting the interest rate (self.p) with the repayment amount, so this needs to be a distinct field in the class:

Silly mistake - I forgot to assign Tool & assetRegister values and therefore did not pick up any workbook:

To create a double-sided bar chart, you can create two subplots with shared x- and y-axis. Each subplot is a horizontal bar chart with a specified marker color

Refer to How to Use GridLayout.
Here is a quote from that Web page:

A GridLayout object places components in a grid of cells. Each component takes all the available space within its cell, and each cell is exactly the same size.

In other words, GridLayout does not consider the preferred size of the components it contains.

A layout manager that does consider its contained components' preferred size is GridBagLayout.

BorderLayout only respects part of its contained components' preferred size. For the EAST component, BorderLayout uses its preferred width but not its preferred height. BorderLayout will initially use its CENTER component's preferred width and height.

This is the window I get when I run your code.

Here is your modified code using GridBagLayout instead of GridLayout.

We can use re to extract all of the words in our list. Noting, this will only match words in your list, not numbers.

Then apply a function that returns a dict with the count of each word in the list. We can then apply this function to a new column in the df.

You need to pass the value of `{{widgets.Mortgage_info.Digits}}`` into the Twilio Function via the Run Function Widget Function Parameters.

You can see how this may work by looking at this code example.

Using Run Function widget in Studio

Db2 is behaving correctly here, it is saying there is no such invoice key as '00100' (for the first insert into payment). The reason is your invoice.inv_id is CHAR(5), but when you insert into invoice you specify only four characters in the values statements for the invoice key, missing the leading zero!

By the way, it is good practice to always explicitly name the insert column names.

So change your insert statements as follows, notice the key length is 5 characters:

This is certainly possible and a very common use case for Twilio Studio. For development, you could use a flat file hosted on Twilio Assets to host the JSON but in production, you would interface with a REST API exposed by your backend data source you are using to lookup the Mortgage id and return the associated information.

Below is an example parsing JSON from a Twilio Asset. You could also use Twilio Sync, here is a CRUD code example using Twilio Functions, understanding that Sync is not a replacement for a high performance DB.

You could also use Airtable.

Using Airtable as a database for your Twilio app

Writing to Airtable from your Twilio app

Reading / Parsing a Twilio Asset