Jump to content
Sign in to follow this  
Mike J

Recursive Code Generator

Recommended Posts

Hope everyone is well. Been working hard on creating some personal DB and came across a need that I can't figure out.

Recursive Calculation that generates a code.

Two Tables:

Order

Line Item

I have several line items related to an order. I have field in the order table that (Scripting/Recursive Calc) will look at several fields in a line item and generate a CSV for that line item.

(Example below of two line items strung together).

[color:blue]DLFP,Probe 1,6ACTGTGCATACCCATAGCGT[3BQ1],0.2,HPLC,ShipComplete

[color:purple]STND,Probe2,6ACTGTGCATACCCATAGCGT[3BQ1],0.2,DESALT,ShipComplete

One thought to generate the code would be to step through it using a script to set a order code field in the order table. I was wondering if there was simpler way using a calc field in the order table to filter through each line item through a portal relationship.

MJ

Share this post


Link to post
Share on other sites

You would need the Advanced version to create a recursive custom function. Without it, script would be the way to go.

Share this post


Link to post
Share on other sites

You could generate each line in a calculation field in LineItems. Then put them together in another calculation field in the Order table = List ( LineItems::calcfield ).

If this intended for export, you might be disappointed.

Share this post


Link to post
Share on other sites

Thanks Comment...

Did the list and it works, but will use the information for cut paste into a web browser field.

Thanks

Mike

Edited by Guest

Share this post


Link to post
Share on other sites

I have the Advanced version, what would be your custom function?

Is there a problem with List (Field;{Field} when using commas?

I used your directions, made the calc in list table and used the List Function to pull that info in?

Thoughts?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.