Your Setup:
- SeaTable Enterprise 6.0.10 self-hosted
Describe the Problem/Error/Question:
I am trying to refer to a collaborator column from a formula. Simple enough: {column name}. Works almost as expected. However:
- For some users, the formula resolved the clear name
John Doe - For others, it resolves to the internal ID
df606c7e15f345dfac77507b5f7b4976@auth.local
I looked at the user data from the /api/v2.1/admin/users/endpoint, and I could only find one consistent hint at what is going on. We have defined different roles on our server (@rdb knows why)
'full': {
'can_add_dtable': True,
'can_add_group': True,
'can_use_global_address_book': True,
'can_invite_guest': False,
'role_quota': '',
'role_asset_quota': '',
'row_limit': -1,
'can_create_common_dataset': True,
'can_generate_external_link': True,
'can_run_python_script': True,
'can_schedule_run_script': True,
'scripts_running_limit': -1,
'can_use_advanced_permissions': True,
'can_use_advanced_customization': True,
'can_use_external_app': True,
'can_use_automation_rules': True,
'snapshot_days': 180,
'share_limit': 100,
'can_archive_rows': True,
'big_data_row_limit': -1
},
'limited': {
'can_add_dtable': False,
'can_add_group': False,
'can_use_global_address_book': True,
'can_invite_guest': False,
'role_quota': '',
'role_asset_quota': '',
'row_limit': -1,
'can_create_common_dataset': False,
'can_generate_external_link': False,
'can_run_python_script': False,
'can_schedule_run_script': True,
'scripts_running_limit': -1,
'can_use_advanced_permissions': True,
'can_use_advanced_customization': True,
'can_use_external_app': False,
'can_use_automation_rules': False,
'snapshot_days': 180,
'share_limit': 100,
'can_archive_rows': False,
'big_data_row_limit': -1
},
User with role “full“ are resolved into clear names by the formula, users with role “limited“ are resolved to the internal account ID.
This is totally weird, and I can only attribute this to some weird side effect.
One important addition: Changing the role in the Admin settings does not fix this immediately. If it fixes it after some time, I don’t know - I’ll let you know if the role changes I just did will change something after some time.
