Get a sequential range from two fields & then auto-gen the fields?

[thegooglemoogle]

Hi all,

Question 1:

Is it possible to have 2 fields produce a sequential range that will then be placed into auto-generated fields to hold the results?

I took a look at Dynamically Generating Number Ranges & it was close but was set to only allow numbers for entry & only a set amount of fields while I would like to use text & automatically create each field based on each text occurrence.

Here is what I would like to do but have not seen done anywhere before:

There is a beginning field & an ending field.

You enter "a1" in the beginning field & then enter "a100" in the ending field. The phrase "a1" is not limited in any way. It could be "b11b" to "b99b" etc.

You click a button w/script attached (or something better?) & it then takes the range from both fields & creates a new field for each sequential "a1" to "a100" occurrence filled with that text.

Each field would also receive a label for each "a1" to "a100" as well.

This newly created set of fields would then be sent to a custom web address through a web viewer object where it would be processed through a javascript data grid to produce a printer specific label sheet in html format.

Question 2:

Can I skip the manifestation of the created fields on a layout & just have the data generate from a custom function through the custom web address in a web viewer object into a javascript data grid?

I asked about part of my app in the post Insert Fields dynamically into an Object or vice versa? & received the grand idea of running this through the web viewer from Fabrice which when I looked into javascript seemed perfectly feasible.

Fenton suggested a portal which sounds right as a possible facilitator of the data but is it necessary?

Does anything I said make any sense? It's late.

Thank you in advance,

thegooglemoogle

[comment]

You cannot generate fields dynamically. Fields can be created only when defining the database.

Why don't you use a labels layout? You can easily generate the required values as records in another table - see attached file.

Labels.fp7.zip

[thegooglemoogle]

Thank you very much!

This is exactly what I need to get started.

I really appreciate how helpful you & all the gang are around this forum.

Best,

thegooglemoogle

[thegooglemoogle]

Hi again,

So I tried out your file more in depth & it works great.

But I have a question:

Can you make the script allow for blanks to be generated on purpose w/o any text?

The reason is to allow for labels that would be printed with just a border & then someone to hand write on the blank label.

Thanks,

thegooglemoogle

[comment]

It should be easy: for example, you could generate the total amount, then go back and set the field to empty on the labels you want empty.

[thegooglemoogle]

Hi,

OK. I will give it a try.

Thanks again.

Best,

thegooglemoogle