Removing the @text from a list from a connected table?

1

Simple SOP doc but I am trying to show the steps as text instead of a table or a link. How do I change the format of the “Where this Procedure starts” text? The formulas I’m trying are also removing the data structure and its no longer in bullets.

2

Hi @Keith_Kolomichuk :blush: !

This seems to work :blush:

Inputs.filter(
  [Column 3].SOP = [Kolo SOP Select]
).Input.BulletedList()

Where this Procedure starts
Where this Procedure starts1152×540 38.4 KB

Once Filter() returns the appropriate list of rows from your table Input, you just need to access/dereference the desired text value for the rows in that list… which here is the value in your field Input … and then apply on the list of now text values NumberedList() or BulletedList() to format it :blush:.

Same goes for your Column 3 within the Filter(): Instead of using ToText() on Column 3, you can simply access the appropriate value to make the comparison work (which is here, the value in the field SOP) :blush: .

3

Thank you! thats perfect

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.