How do I pull data from a get(LayoutTableName) to a variable?

November 11, 201114 yr

Newbies

I have been racking my brain on this one, just cant seem to figure it out.

I have a script which is used on our many product lines, each has it own database based on the criteria of our various customer's requirements, but they have a specific naming convention.

So the script is placing data into the table using " Get(LayoutTableName)&"::Ship_Date" ", but I need it to validate if it even exists before I replace it. I want to enter ONLY if there is no data, not replace it.

What I am tring to do is validate that the field is not empty, if it is empty, I will insert a date. Seems simple, I have tried " not(isEmpty(Get(LayoutTableName)&"::Ship_Date" )) " and it does not work, it is pulling " TableName::Ship_Date " and saying it is not empty. Its not actually looking at the data in the record.

I tried assigning to a variable, and the variable also ends up being " TableName::Ship_Date ".

I'm sure its a simple fix, just can't wrap my brain around it.