Remove empty items from lookupRecords list

Ask for Help
1

Mostly wondering if there is a simpler / more direct / elegant way of removing empty records from a lookupRecords list. Here’s what I’m using:

statuses = []
records = Laptops.lookupRecords(refName=$id).status
for record_item in records:
  if record_item == '':
    pass
  else:
    statuses.append(record_item)
return statuses

Looking forward to seeing what else I could’ve done.

Thanks for looking.

2 
[status for status in Laptops.lookupRecords(refName=$id).status if status]
3 Likes
3

Nice! I need to learn more about how you structured that. I get that the [ ] puts the results into an array. The status for is what I’m not sure about. Is it the equivalent of status = ?

4

It’s called a list comprehension.

3 Likes
5

I think I face a similar issue. I am trying to sum all the items from a financial column “Price” only for the lines which respect “Year=$Year” and “Products=None”. This last item (Products=None) is malfunctioning. Products is a multiple reference column pointing to another table.
I tried to apply the for loop but without success.