Home

Dynamic Arrays and validation lists - How to make dynamic arrays follow a structured table?

%3CLINGO-SUB%20id%3D%22lingo-sub-485516%22%20slang%3D%22en-US%22%3EDynamic%20Arrays%20and%20validation%20lists%20-%20How%20to%20make%20dynamic%20arrays%20follow%20a%20structured%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-485516%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20table%20where%20a%20given%20field%2Fcolumn%20has%20content%20pulled%20from%20a%20validation%20list%3B%20this%20validation%20list%20is%20based%20off%20a%20dynamic%20array%2C%20which%20is%20returning%20the%20correct%20values.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20essence%3A%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Table%201%3A%20%3CSTRONG%3EClients%3C%2FSTRONG%3E%20(field%20%22ID%23%22%20for%20cross-referencing)%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Table%202%3A%20%3CSTRONG%3EProjects%3C%2FSTRONG%3E%20(with%20manual%20insertion%20of%20Client%20%22ID%23%22%20for%20future%20cross-referencing)%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Table%203%3A%20%3CSTRONG%3EDocuments%3C%2FSTRONG%3E%20(also%20with%26nbsp%3Bmanual%20insertion%20of%20Client%20%22ID%23%22%20for%20future%20cross-referencing)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20line%20on%20table%203%20(below)%20will%20have%20a%20different%20set%20of%20values%20in%20the%20validation%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20intended%20behavior%2C%20that%20you%20can%20see%20in%20the%20table%20attached%20is%20that%20in%20Table%203%2C%20%22Related%20Project%22%2C%20is%20that%20the%20validation%20list%20made%20available%20will%20offer%20a%20selection%20of%20%3CSTRONG%3EProjects%3C%2FSTRONG%3E%20related%20to%20that%20%3CSTRONG%3EClient%3C%2FSTRONG%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20I'm%20looking%20for%20help%20with%20is%20on%20how%20to%20make%20the%20dynamic%20arrays%20expand%2Freduce%20dynamically%20with%20the%20%22Documents%22%20table%2C%20so%20that%20the%20end%20user%20doesn't%20have%20to%20manually%20expand%20the%20cells%20where%20the%20dynamic%20arrays%20are%20being%20created.%20I'm%20using%20structured%20tables%20throughout%20and%20it%20would%20be%20nice%20if%20they%20could%20accommodate%20transpose%20spill%20functions%2C%20but%20that's%20not%20the%20case.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-485516%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Adriano Neves
New Contributor

Hi,

 

I'm trying to create a table where a given field/column has content pulled from a validation list; this validation list is based off a dynamic array, which is returning the correct values. 

 

In essence:

 - Table 1: Clients (field "ID#" for cross-referencing)

 - Table 2: Projects (with manual insertion of Client "ID#" for future cross-referencing)

 - Table 3: Documents (also with manual insertion of Client "ID#" for future cross-referencing)

 

Each line on table 3 (below) will have a different set of values in the validation list. 

 

The intended behavior, that you can see in the table attached is that in Table 3, "Related Project", is that the validation list made available will offer a selection of Projects related to that Client

 

The issue I'm looking for help with is on how to make the dynamic arrays expand/reduce dynamically with the "Documents" table, so that the end user doesn't have to manually expand the cells where the dynamic arrays are being created. I'm using structured tables throughout and it would be nice if they could accommodate transpose spill functions, but that's not the case. 

 

Thanks

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies