Pull entire column from a view of a larger table

1

Hi all!

I have a table that is being populated by an external source and I am using a view to filter only relevant data from it. I want to copy one column from that view to a new table programmatically so that it remains up to date if I change the data or the view. I can’t seem to find a way to do this with formulae since everything seems to require filtering by an associated value. I don’t want anything filtered since that is handled by the view I already have. Is there any way to do this?

2

HI ,

Could you share your doc, or a redacted copy of it, with an explanation of what you need.

Changing data, and changing views are two independent topics - how do they influence the new table you want?

3

If you use the View as a source, then you don’t have to apply any (additional) filters to your formula.
Imagine you have a table named Source (with 50 records) and a (filtered) view of that table named SourceView, using the following formula will result in only processing the visible records from the view:

image
image554×138 10.7 KB

where the green Name object is actually currentvalue.Name.

4

Thank you for your responses! I have come to the conclusion that what I was looking into doing will not work and had to change strategies! The ForEach option is something that might have worked for what I was requesting but the formula solution isn’t possible for what I had to do next!

But thanks again, @Piet_Strydom and @joost_mineur ! I appreciate your quick replies!