I have do lookup on my Organisation table which connect to Contact table.
I can successfully pull the data from Contact table and display into Organisation table in condition if the organization have the contact. That is work.
I am using this function : Contacts.Filter(Organization.Contains(thisRow))
The problem is for those organisation who do not have a contact yet, the row is empty and I somehow cannot edit or update the row.
Is there other way I can still update the row after the lookup is done betwwen two table.
I am getting this error massage: Values in this column are calculated by a formula and can’t be directly changedEdit formula
Need help anyone please. =)