I have a [Ref] set up to pull data from another table.
If you preview the data, it is pulling the correct data, in this case [column 2], but when you save that data into the table it is saving [column 1].
Any ideas why this might be happening?
[column 2] in the parent table is the label, I don't know if this will be having an effect?
Solved! Go to Solution.
Key column shall be a column, which stores unique values in each row for the table.
You may please check if the existing Key column will satisfy this condition. Otherwise, you may have to workaround something.
I usually prefer UNIQUEID() as initial value of the Key column. So, that all the values will be unique for the table.
Regards,
Srikanth.
Hi,
You are correct.
In case of Reference table, Key column is stored in the child table, in your case [Column 1].
While displaying in the app it will show the Label column [Column 2].
In case, you want to [Column 1] as display also, change the Parent table's label as [Column 1] - same as key column.
Regards,
Srikanth.
Hi Srikanth,
That's really helpful, thank you! I think I have a better understanding of how Keys and Labels work.
The issue I have now is I cannot set [Column 2] (the one I want to save in the new table) as a Key because it contains a formula (It pulls data in real-time from another sheet of active employees).
Do I need to rebuild my system or is there a work-around?
Key column shall be a column, which stores unique values in each row for the table.
You may please check if the existing Key column will satisfy this condition. Otherwise, you may have to workaround something.
I usually prefer UNIQUEID() as initial value of the Key column. So, that all the values will be unique for the table.
Regards,
Srikanth.
User | Count |
---|---|
27 | |
26 | |
22 | |
22 | |
21 |