Thank you for your post.
What values to you get for each of the variables inside the Let function? For example, what is the result of _Fn? If the value in _Fn looks correct, then continue with the remaining variables.
Try putting these values into fields to make sure it works before moving it to a custom function.
I'm not too sharp with deconstructing the let statement:
my crude understanding is .. Let ( [declare values]; calc(s); result)
Since if I'm after field id only i should be able to negate some of the element declaring that doesn't apply.
It's unclear as to how to test
declaration1 > don't need it if i hard wire Filename
declaration 2 > type= "Layout" so _Fn = "LayoutIDs" ; FieldIDs = "LayoutIDs";"Layout"
declaration 3 > type= "Layout" so _Fn = "LayoutNames" ; FieldNames = "LayoutNames";"Layout"
Create separate calculation fields for FN, ID, N, p1, n1 and p2. This should probably give you an idea what is not working.
a bit of critical thinking is needed to solve the problem
- This isn't a product issue is it?
- Custom Functions posted to public web sites generally work. If not, approach the author.
- If a function that is known to work fails for you then you aren't feeding it the right food.
- you say you are sending the table::field. If that field reference can be resolved it will send the data found inside the field, not the field name.
- use GetFieldname( table::field ) to get the field name