LINKTOFORM not passing everyvalue

AppSheet AppSheet Q&A
1

The follwing expression:

LINKTOFORM(“PROGLAMFORM”,“orden”,[_THISROW].[orden],“SKU”,[_THISROW].[SKU],“FechaPrograma”,today(),“Familia actualizada”,[_thisrow].[Familia Actualizada],“Tipo”, [_THISROW].[Tipo],“Color”, [_THISROW].[Color],“Prioridad”, [_THISROW].[Prioridad],“sección”, any(usuario[Seccion]),“P-Lam-Punzonado”,[_THISROW].[R-Lam-Punzonado],“P-Lam-Doblez”,[_THISROW].[Q-Lam-Doblez],“P-Lam-Sol Mig”,[_THISROW].[Q-Lam-Sol Mig])

Some values pass ok to the form but the finals one do not:

…P-Lam-Punzonado",[_THISROW].[R-Lam-Punzonado],“P-Lam-Doblez”,[_THISROW].[Q-Lam-Doblez],“P-Lam-Sol Mig”,[_THISROW].[Q-Lam-Sol Mig]

I have checked column names, and still havent found why theses values do not pass ok.

I have other similar expressions and they work ok.

2

If you didn’t already, confirm those columns are editable and the values are valid.

1 Like
3

Thanks for your replay, but yes already confirmed those aspects.

1 Like
4

There are 2 possibilities imo,

  1. Those values are not passing a data validation or data type, or maybe even an edit_If constraint (Which to be honest I don’t think it is the case because the whole row wouldn’t be recorded at all instead of it recording partially as you describe.)

possibility 2. If the error is persisting just with that particular record then it is indeed not finding any record for those last values. (Which I think is the most likely thing happening)

Edit: Just to be sure, try regenerating both tables, sometimes the error is in there and don’t know why but recent updates won’t mark this type of errors.

1 Like
5

Remove all occurrences of [_THISROW]. in your expression–none of them are needed. I have experienced times where its inclusion produced unexpected results.

2 Likes