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 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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Lee Smith 
×
×
  • Create New...

Important Information

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