Hi all,
Some context: I have multiple bases with a list of tags that can be associated with records in other tables through a linked record field. If the users cannot find the tag they need, they can enter it as a new tag, but due to view permissions, any new tags created by these users will be given the status "requested" from a single select field. The single-select field can only be changed by an admin through a script triggered by a button, effectively "approving" the request.
Since these admins will be handling requests from many various bases, I wish to create a common location for all of the requests, so they don't have to switch between bases to approve/deny requests. I first tried to accomplish this with an interface, but since the scripts don't work in the interfaces, this won't work. I then thought to go for a simpler solution: creating a synced table in a "master-base" with multiple source tables, listing the "requests".
However:
- I need to indicate which source table the record is synced from in a field in the record so the approver has context for the tag. How can I reference the table name? Is there a way to do this through a formula field similar to record_ID()?
- The buttons triggering the scripts in the source tables cannot be triggered from the destination table. Is there a workaround for this anyone has found? Can I trigger a script that works across bases? If so, I imagine step 1 is dependent on this as I would need to know the table name or ID to define the variable ${table.name} in the script.
Appreciate any input/workaround/ideas you may have on this!
