I encountered similar problem (but with lookup of a currency field) an hour ago and find this topic ))
Well, I’m understand what’s wrong and already thought about possible workarounds, just came to check maybe I miss something, and there is a better solution.
The field you called lookup, is not a lookup, it’s the ‘link’(or linked field), the field joining two tables.
Lookup is a “function” that find a value (or values) in second table and reflect it in first table, according to the links you set up in the link field. And Rollup is advanced version of Lookup letting you apply formula for lookup results.
(Sorry for this explanaition, 3 months ago when i started to work with Airtables, i was confisued with all those concept and would be happy if someone explain it to me)
Well, the problem is that Sync process mandatory converts some data, including links and lookup results, to a simple text. So, there are 2 ways to solve it:
- use another sync to pass desired value directly to the place where you want to see it,
- or find a way to maintain links in a synced field via automations.
i don’t like both, but I don’t know other solutions.
Creating automation is not hard but i’m usually prefer ‘native table functions’ to avoid extra possible weak spots. Plurality should not be posited without necessity :grinning:
Anyway, i will share my solution here, in case of lack of better ideas.