Data from another table

Ask for Help
1

Hello to all,

Can I reference data from another table in a custom function like vlookup or if-then-else or something similar to relations ?

Recording

Thank you.

2

You need a Relation column and a Lookup column. Suggest reviewing the following information:

3

I looked into those but if the data in the users table has a row owner, that data still will not be available only with a relation. Any other suggestions … even an excel formula will help

4

No, if row owners are applied, then only the owned data is available to work with.

5

I’ve had an idea but it doesn’t work as I expected for photos …
so, I’ve created a button that triggers an action to add a row with that user’s data in another table … all good but the photo field is not completed … is this a bug that can be resolved ?

image
image996×1082 71.8 KB

6

It works know … sorry for the trouble … the first action didn’t worked properly , but now it works great and I can create what I want like this and also keep the users table secured with row owners. Thanks.