Hi, I have a look up field on airtable (an email field), stacker transforms it in a "long text field" and then I cannot compare it with a filter to the user's email (which is a short text field). Would you have an idea of how to repair this ? (My app has been broken for a month, I have just manage to find the bug ...)

@salmon-electrician-92054 I believe you can change the field type from the fields interface directly inside stacker. It’s probably worth having a look. You can probably change the type of the field right from there.

No unfortunately, it is not possible...

Then maybe on airtable directly? A lookup may be configured sometimes, I know it happens with Rollup (“Format” tab)

No the "format" can be only configured for dates and numbers in AT ... 😪 I ve tried to disconnect my table, have changed the rollup field to display only one value and reconnected but now the sync is dead 😭

Can you try refreshing your screen for the support chat to reload? That helped me.

@salmon-electrician-92054 we encounter a similar issue with synced tables. We use a formula field in Airtable that just equals the "long text" field, which converts it to a single line text output. @silly-pharmacist-44942 ideally this issue would be solved if we could choose long text as a field for user email. It's not "right", but since Airtable tends to present lookups and synced tables that way it would be a good workaround.