hi,
looks like this:
when (deleted and) created TYPE is always Number and I change to Text.
I have other APPS with VCโs that calculate from columns in the same table they are in,
but this time i need to read from another table in the APP, is this the reason it fails?
cheers,
Mike
an update, team.
i moved the formula iโm trying to get to stop desplaying NaN:
LOOKUP([STAFF MEMBER], โSTAFF LISTโ, โE-Mail Addressโ, โDATE STARTโ)
to a Text TYPE column in the table, as opposed to Virtual,
and still get the same error!
column โDATE STARTโ in table โSTAFF LISTโ is Text Format and static values like:
Mon 11/11/2019
stumped!
And further,
if i change my formula to read another text column like this:
LOOKUP([STAFF MEMBER], โSTAFF LISTโ, โE-Mail Addressโ, โDATE STARTโ)
it works fine
apologies for the typo:
And further,
if i change my formula to read another text column like this:
LOOKUP([STAFF MEMBER], โSTAFF LISTโ, โE-Mail Addressโ, โLOCATIONโ)
it works fine
Interesting,
in the Columns definition,
if i move my formula from INITIAL VALUE and put it in FORMULA,
or viceversa
the TYPE changes automatically from Text to Number. ?
so i am forced to change it to Txt.
just to test, i changed the TYPE to Date, and it gave this error:
The expression is valid but its result type โNumberโ is not one of the expected types: Date
so, the LOOKUP yields a number result from a text columnโฆ
back to TYPE Text, even this fails with NaN:
CONCATENATE(" ",LOOKUP([STAFF MEMBER], โSTAFF LISTโ, โE-Mail Addressโ, โDATE STARTโ))
!?
Please try to use LOOKUP([_THISROW].[STAFF MEMBER],โSTAFF LISTโ,โE-Mail Addressโ,โDATE STARTโ)
I'm having a variation on this problem.
When I'm viewing the record in the form, it shows the text field's normal value (in this case, a "K"). When I edit the record in the form, it changes to NaN.
No idea what's going on here.
Please start a new topic for help with this.
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |