Prepend currency symbol to fields in the table view of an AppGini app

footer-extras.php

<?php if(Request::val('Print_x')) : ?>
  <style>
    /* format is: td.{tablename}-{fieldname} */
    td.orders-Total::before,
    td.order_details-UnitPrice::before,
    td.order_details-SubTotal::before  /* Attention: no comma (,) after last field! */
      { content: '₹'; }
  </style>
<?php else : ?>
  <style>
    td.orders-Total > a::before,
    td.order_details-UnitPrice > a::before,
    td.order_details-SubTotal > a::before  /* Attention: no comma (,) after last field! */
      { content: '₹'; }
  </style>
<?php endif; ?>

Add currency symbol in table view for the amount column in your AppGini app

AppGini provides a way to add currency symbols to amount columns in table view. This can be done by using the Data format tab for the concerned field. Here is an example screenshot:

The problem with this approach is that only a very few number of currency symbols are available in the drop-down list. You can add more currency symbols by editing the C:\Program Files\AppGini\add-ons\dataFormats.cfg file, as the context help suggests. However, this is not a very user-friendly approach.

A much easier way to add currency symbols is to use the CSS ::before pseudo-element to configure the currency symbol in the content property for all amount columns. To do so, open the generated hooks/footer-extras.php file and add the above code at the end of the file.

The first block in the above code (lines 2-8) configure the currency symbol (₹ in this case, which is the Indian Rupee symbol) for the amount columns in the print view:

The second block (lines 10-15) configures the currency symbol for the amount columns in the table view:

You can customize the currency symbol by changing the content property in the CSS code. Here is a list of world currency symbols for your reference.

To specify a specific amount field in the above code, you can use the format td.{tablename}-{fieldname}. For example, if you have a table named invoices and an amount field named total, you can specify the currency symbol for this field in the table view by using the CSS class td.invoices-total.

This approach is much more user-friendly than editing the dataFormats.cfg file, as it allows you to specify any currency symbol you want without having to edit any files outside the hooks folder, and moreover, it affects just the display of the currency symbol without modifying the actual database query.