problem with ref columns

[jpruezkiez]

hello, i am having an issue regarding REF data type, i have an employee list and attendance table, the attendance table has a column for the name, clock time, out time and day, i added an action to add a new record to the attendance table when i click it, however, it seems to add it without problem, but it's not being reference. i will provide images below:

this is the employee information

and this is the attendance table:

when i add the record manually, it gets referenced.

however i need to be able to do it automatically with an action. but when i do it when the action, that new added record doesnt get linked to the employee and appears with a yellow triangle.

the action i am using looks like this:

i really do not any approach to fix this, any tip or information that you can provide me, i would be very happy.

[Marc_Dillon]

logs[Name] is the Ref column to Table1? Is [Employee] the key column in Table1? I'm guessing it is not, but that it's the Label column. You need to to put key values into Ref columns. Read the following articles, and also search this forum for "yellow triangle" for more info.

https://help.appsheet.com/en/articles/961426-references-between-tables

https://help.appsheet.com/en/articles/1023086-what-is-a-key

https://help.appsheet.com/en/articles/961466-row-labels