Auto Suggestion feature in Confluence

[HQRAZAHS]

Hello Folks. I need one help. Below is my problem explanation along with Expected Solution. Please review the same and help me to provide a suitable resolution.

📌 Objective:

We are maintaining a Risk-Issue table in Confluence, where data is copied from Excel. This table is used as input for the Pivot Table macro to generate a Risk Owner Matrix. One of the key columns in this table is "Assignee", which captures the name of the Risk/Issue owner.

---

🎯 Challenge:

Currently, the "Assignee" field is a free-text input. This leads to several issues:

• Inconsistent naming: For example, my name "Md Ahsan Raza" might be entered as "Ahsan", "Raza", or "Ahsan Raza".
• Spelling errors: Mistakes like "Ahsab" can occur.
• Data fragmentation: These inconsistencies distort the accuracy of the Risk Owner Matrix, especially when the dataset grows to hundreds or thousands of records.

---

✅ Expected Solution:

To ensure data consistency and reduce manual errors, I am looking for a way to implement an auto-suggestion or dropdown feature in the "Assignee" column. This would:

• Provide a predefined list of valid names.
• Allow users to select from suggestions as they type.
• Minimize the risk of typos or inconsistent entries.
• Ensure the Pivot Table output remains accurate and reliable.

[Tomislav Tobijas]

Hi @HQRAZAHS ,

Just to confirm—are you using native Confluence tables or some third-party (Marketplace) app for Risk-Issue table?

Native feature doesn't have an option to add a dropdown/list, but maybe you could use Confluence databases and the tag field type in there 🤔

If it's the Marketplace app, the best bet would probably be to reach out to the vendor and see if they can add any insights or potentially workarounds you could use.

Cheers,
Tobi