Jump to content

Recursive Code Generator


This topic is 6160 days old. Please don't post here. Open a new topic instead.

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

Link to comment
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.

Link to comment
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
Link to comment
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?

Link to comment
Share on other sites

This topic is 6160 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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