Jump to content

Row script: Difference between revisions

From Resco's Wiki
Marek Rodak (talk | contribs)
No edit summary
Marek Rodak (talk | contribs)
No edit summary
Line 35: Line 35:


{{Note|Do not use [[Rules_editor#Entity_type|LoadFetch, LoadReference, and NewInstance]] in row scripts, even if Woodford allows you to configure them. These asynchronous operations do not work in this context and can cause problems.|Warning}}
{{Note|Do not use [[Rules_editor#Entity_type|LoadFetch, LoadReference, and NewInstance]] in row scripts, even if Woodford allows you to configure them. These asynchronous operations do not work in this context and can cause problems.|Warning}}
==Custom field on the view==
In this example, we create a custom field which we add to the row on the Order view.
We create a new string variable where we add following string: ''{Entity.customerid}: {Entity.name}''.
[[File:Rowscript custom field.PNG]]
Next, we add this variable to our row.
[[File:ViewEditor custom field.PNG|600px]]
This is how it looks in the application.
[[File:Inapp custom field.PNG|600px]]


== Change style on view dynamically ==
== Change style on view dynamically ==

Revision as of 12:05, 29 December 2023

Warning Work in progress! We are in the process of updating the information on this page. Subject to change.

You can define multiple row designs for a view, and then you can define conditions when a specific row design should be used. Additionally, you can create a custom variable and define a custom field on the view. Row script rules are evaluated for each row during either loading or refreshing of the view.

Note Please check this blog post for an additional example of row script use. Blog

Multiple views example

In the following example, we will create a second row with a red background, this will be used when the field Name does not contain data.

Create a new style with red background

  1. Click Edit Styles to display the Style editor.
  2. Select primary from the style list, and then click Add. This creates a clone of the primary style.
  3. Change the BackColor (background), ForeColor (text color), and rename the style (for example Red Primary).
  4. Click Save & Close to close the styles editor and return to the view designer.

Create a second row

You have multiple options for creating rows:

  • Click Clone Row to create a copy of the row selected in the Properties pane. Then rename the row, for example to RedRow.
  • Click Add Row to create an empty row, where you can add fields and design it from scratch.
  • You can also click Copy Design to copy the design of any view from any entity.

In the new row, select a cell and change the style from Primary to Red Primary.

Create a row script

To define when and how the different the row designs are used, you need to set up a row script. Row script is a combination of steps and conditions (what should happen and when).

  1. Click Row Script to open the script editor.
  2. Add the following conditions and steps.
    If entity.name does not contain data
    Then Step TemplateIndex Assign RedRow
    Else Step TemplateIndex Assign Default
  3. Click Save & Close.
Warning Do not use LoadFetch, LoadReference, and NewInstance in row scripts, even if Woodford allows you to configure them. These asynchronous operations do not work in this context and can cause problems.

Custom field on the view

In this example, we create a custom field which we add to the row on the Order view. We create a new string variable where we add following string: {Entity.customerid}: {Entity.name}.

Next, we add this variable to our row.

This is how it looks in the application.

Change style on view dynamically

Since version 10.1, there is also a different option in changing the field style on view dynamically, based on its value or other conditions instead of creating a different row design. It is also possible to change the field’s style by using Row Script directly.

To learn more about this approach, please check this part of WEBINAR and HERE to see the setup and see it in action. Webinar




{{#CI form: title = Was this information helpful? How can we improve? | type = inputs | [textarea] }}