Return Linked Table Fields from TextBlaze

Questions and Help
1

Hello everyone,

I have a DataBlaze Space with multiple tables. Many of them are linked to each other. Sometimes with multiple items per field (Example: semesters are linked to a FAFSA year. Leading to each FAFSA being linked to several semesters, etc...)

I wanted to know if there was a way to;

  1. Convert these linked fields into lists (If FAFSA1 is linked to semesters A, B, & C. Can I create a bullet, numbered, or unmarked list?)
  2. Can I pull a specific value from the linked field? (If there are three values, can I return just the second and third linked fields?)
  3. Finally, can I use these values as conditions for which rows to read from that table? (If I have a list of semesters, can I only read from the ones that connnect a specific FAFSA?)

I appreciate any help you can offer on any of these goals. Solving even one would improve the flow of about a dozen snippets.

2

Hi @COREY_CHARLE.

Sure I can help you on this, I prepared a sample space with example snippets for each point of your questions, I hope they help you. Please let me know if need any explainations or modifications to any of the shared snippet examples:

3

Unreal. It only took 1 day to solve this. Thank you so much for your help! I'll have to play with repeat more. Now that I've seen it work I can think of several instances where it will make life much easier.

1 Like