How can I still edit /update the data after the lookup on two table are connected

Hi guys,

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. =)

1 Like