Asking for a friend:)
How can I generate a parametric list of locations?
I am messing with EDGEARRAY token and the first parameter is the list of numbers that determine the location of the hardware.
What I am trying to do is to write a formula that generates the List based on the Length of the Panel and Distance Between the hardware items.
I will have a hidden prompt to store the Qty of the hardware.
Is there a formula or function that generates a list in which the number of values varies? I do not want to have a preset list of values.
Example1: 20" long part, distance between Hardware items 5" Generated List :5,10,15
Example2: 30" Long part, distance between Hardware Items 6", Generated List : 3,9,15,21,27
Of course they will be placed equally along the edge, but for now lets ignore that.
If you wondering for what I need it, is to place the Smart Clips on Plam counter Backsplashes. But I think it could have more applications than this.
Any help or directions would be appreciated.
Thanks.