How to add a column dynamically to a repeating panel

[alexri]

I have a repeating panel inside a data grid. I fetch the rows from database and assign the rows to the repeating panel items. Based on the values of the columns for each row I want to calculate something and based on the result I want to then display a image or string on a new column for each row (ie ‘warning’,‘ok’,‘error’ etc). Is it possible to do this? How do I loop through each row in a repeating panel and add this column dynamically?

[navigate]

You can change the rows anytime using the items attribute of a repeating panel. I typically feed repeating panes a list of dicts. It might look something like:

self.repeating_panel.items = [{'foo':'bar','message':OK}]

To add a row to the bottom of this repeating panel, you could use

self.repeating_panel.items.append({'foo':'baz','message':'Error!'})

[stucork]

a quick note that using append alone isn’t enough here.
Use either:

self.repeating_panel.items.append({'foo':'baz','message':'Error!'})
self.repeating_panel.items = self.repeating_panel.items

or

self.repeating_panel.items = self.repeating_panel.items  +  [{'foo':'baz','message':'Error!'}]

related topics:

Repeating panel to collect new information?

This is exactly the right way to do it. In fact, I would probably create one or more named dummy objects so that I can easily refer to them later. Something like this, perhaps: def __init__(self, **properties): self.init_components(**properties) # When the form is created, populate the RepeatingPanel self.data = [ ...your actual data... ] self.new_item = {"foo": "", "bar": ""} self.repeating_panel_1.items = self.data + [self.new_item] def save_new_item_click (se…

RepeatingPanel add_component method

The great thing about repeating panels: set the items with a list of length n --> n item_templates appear with the item property set The not so great thing about repeating panels: If the list is long or the item_template has many data_bindings the form can take a long time to load If the list changes, say by deleting an item or adding an item, then it can be a UI nightmare to have to repopulate the item_templates of a repeating_panel deleting an item works well: You don’t need…

---

regarding how to loop over the repeating panels - you have some optoins

for componet in repeating_panel.get_components():
  # do something

or use the __init__ method of the ItemTemplate itself

class ItemTemplate(ItemTemplateForm):
   def __init__(self, **properties):
     self.init_components(**properties)
     # now you have self.item
     if self.item['bar']:
        # do something...
        self.bar_component.visible = False

or set databindings on the components of ItemTemplate

---

you might also find this post helpful

Add text boxes to DataGrid Columns programatically

Hello and welcome, You may find the documentation on DataGrids helpful. If you want TextBox components inside the DataRowPanel so that the columns are consistent with the DataGrid, you could try this approach. grid=DataGrid() self.add_component(grid) # create some columns grid.columns = [ { "id": "A", "title": "Name", "data_key": "name" }, { "id": "B", "title": "Address", "data_key": "address" }, { "id": "C", "title": "Age", "data_key": "age" } ] # create some rows of data items = [ {…

[alexri]

Thank you. Ended up using something like this:

    for r in self.repeating_panel_1.get_components():
            pt = r.item['Rank']
            if r.item['English'] is True:
              pt += 1
            if r.item['HighSchool'] is False:
              pt += 1
            if pt <= 3:
              r.grade_image.source = '_/theme/failed.png'
            if pt > 3 and pt < 5:
              r.grade_image.source = '_/theme/pass.png'
            if pt > 6 :
              r.grade_image.source = '_/theme/highest.png'

Notice to access the component in each repeating panel one need to use dot (.) ie r.grade_image.

[stucork]

great!

i’d be tempted to put this in the template init method

class ItemTemplate(ItemTemplateForm):
  def __init__(self, **properties):
    self.init_components(**properties)
    pts = self.item['Rank'] + self.item['English'] + not self.item['HighSchool']
    # True and False can be treated as 1 and 0
    if pts > 6:
      self.grae_image.source = '_/theme/highest.png'
    elif pts > 3: 
      self.grae_image.source = '_/theme/pass.png'
    else:
      self.grae_image.source = '_/theme/failed.png'