Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

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.

This topic is 4778 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.