I'm using the LINKTOFORM from an action. I'm only tranferring the 'date' field...
I've tried to transfer the colum [Fecha] (date in Spanish), and I've also tried to use TODAY()...
It opens the form without issue, but the date is followed by a yellow triangle, no matter what I do...
I have the following: Parent table is "Minuta", Child table is "Aforo". I'm using the Aforo[Fecha] column as type REF with source table as "Minuta". Aforo[Fecha] is the label for the table.
Table "Minuta" has a virtual column "Related Aforos". The Minuta[Fecha] column is type Date and is also the label for the table.
In the action, the LINKTOFORM Target is:
LINKTOFORM("Aforo_Form","Fecha",today()) and I've also tried:
LINKTOFORM("Aforo_Form","Fecha",[Fecha]).
Both produce the yellow triangle...bu only in the entry field...not as an alert in the upper corner of the app....
What is the error?
In general it sounds like a case of missing reference value.
Search - Google Cloud Community
You have referenced the [FECHA} column in the "Aforo" table to the "Minuta" table but it sounds that you are trying to populate a "free flowing" date such as TODAY() in the "Aforo" table with the action.
With reference relationship, the referenced column will need to have one of the key values from the parent table. Also since you are referencing the "Minuta" table in the [FECHA} column in the "Aforo" table, the key of of one of the records of the "Minuta" table is expected to be populated in the [FECHA} column. So unless the key of the "Minuta" table is a date column, I believe you will get the error anyways.
If you still need more assistance from the community, could you please post the screenshots of the relevant column names and their types in the two tables?
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |