Get all RowIDs instead of call for each one

1

Those of you that do, and those of you that don’t

Is there an API or some kind of trick to fetching all Rows in a table and storing that in a variable? I am trying to do the Satellite training module and don’t want to look at the answer but at the moment, it’s looking like I have to find the IDs of each row and fetch each one individually…was hoping for a “For each” type of command?

Thanks

JA

2

Take a look at FormulaMap. :wink:

3

Nick, legend mate…AND I looked at the solution afterwards and it had 6 more lines of code than FormulaMap achieving the same outcome…you don’t happen to manage resources for a large company do you??? If not, you should!

Thanks mate.

uc?id=1WexrI-9A08T6Dw1D7giXzKA6pNBhQZDS&export=download1016×450

Investor HQ - Confidentiality of Communication

  1. This email and any attachment are confidential and intended for the sole use of the person or entity to whom they are addressed. There may be information contained herein that is covered by solicitor-client privilege. In the event that you are not the addressee of this email or authorised to receive it by the addressee then you have received it in error and any unauthorised use is strictly prohibited. If you have received this email in error please advise us by return email and destroy the original transmission.

  2. As this message is transmitted electronically over the internet, the integrity of this message or any attachment cannot be guaranteed and we are not liable if it has been modified or corrupted. We therefore recommend that you check with us prior to taking any material action based on information contained in this email or any attachment.
1 Like