如何利用Autocomplete字段的POST值过滤获取用户ID？

我有一个可正常显示用户的Autocomplete字段用于选择用户，但无法通过获取的用户名过滤得到对应ID，相关代码如下。请问如何通过POST请求获取的用户名正确过滤出用户ID？

HTML代码 #

<input name="user" id="user" type="text" list='results' placeholder="Type Customer's name" class="form-control">
     <datalist id="results">
       {% for x in results %}
           <option value="{{x.first_name}}"></option>
       {% endfor %}
     </datalist>

views.py代码 #

def customer_note(request):
      if request.method == "POST":
            customer_form = CustomerForm(request.POST)
            if customer_form.is_valid():
                  get_id = customer_form.save(commit=False) # 获取姓名用于后续操作，输入在CustomerForm表单中
                  full_name = User.objects.filter( Q(id__icontains=get_id))
                  customer_form.instance.id =  full_name.id # 此处遇到问题
 . . . 

models.py代码 #

class User(AbstractUser):
    """User can be Employee or Customer"""


class Business(models.Model):
    business = models.CharField(max_length=50)


class Customer(models.Model):
    """ Customer-specific information """
    user = models.OneToOneField(User, on_delete=models.CASCADE, null=True )
    business = models.ForeignKey(Business, on_delete=models.CASCADE, null=True)
    cust_notes = models.CharField(max_length=1000, blank=True)
    selected_cust = models.CharField(max_length=50, blank=True )


class Employee(models.Model):
    """ Employee-specific information """
    user = models.OneToOneField(User, on_delete=models.CASCADE, null=True)
    business = models.ForeignKey(Business,  on_delete=models.CASCADE, null=True, blank=True)

1. 前端数据传递优化（推荐） #

当前datalist仅传递用户的first_name，重名场景下无法区分用户，且后端关联User对象需要ID，建议通过隐藏字段同步传递用户ID：

<input name="user_name" id="user" type="text" list='results' placeholder="输入客户姓名" class="form-control">
<!-- 新增隐藏字段存储用户ID -->
<input type="hidden" name="user_id" id="user_id">

<datalist id="results">
  {% for x in results %}
      <!-- 用data-value存储用户ID -->
      <option data-value="{{x.id}}" value="{{x.first_name}}"></option>
  {% endfor %}
</datalist>

<script>
// 选择选项时同步设置隐藏字段的ID
document.getElementById('user').addEventListener('input', function(e) {
  const selectedOption = Array.from(document.getElementById('results').options).find(opt => opt.value === e.target.value);
  if (selectedOption) {
    document.getElementById('user_id').value = selectedOption.dataset.value;
  } else {
    document.getElementById('user_id').value = '';
  }
});
</script>

提交表单后，后端直接读取request.POST.get('user_id')即可获取用户ID，无需通过姓名查询。

2. 后端逻辑错误修复（若坚持用姓名查询） #

原代码存在3个核心错误，修正如下：

from django.db.models import Q

def customer_note(request):
    if request.method == "POST":
        customer_form = CustomerForm(request.POST)
        if customer_form.is_valid():
            # 直接从POST中获取输入的用户名，而非save(commit=False)返回的Customer实例
            input_name = request.POST.get('user')
            try:
                # 根据first_name精确查询用户，若有重名建议组合last_name一起过滤
                user = User.objects.get(Q(first_name__iexact=input_name))
                # Customer模型关联的是user外键，不是id字段，需设置instance.user
                customer_form.instance.user = user
                customer_form.save()
                # 后续业务逻辑
            except User.DoesNotExist:
                # 处理用户不存在的异常
                customer_form.add_error('user', '该用户不存在')
            except User.MultipleObjectsReturned:
                # 处理重名用户的异常
                customer_form.add_error('user', '存在多个同名用户，请补充姓氏或更精确输入')
        # 其他逻辑

3. Django表单原生优化建议 #

如果使用Django表单，推荐直接用ModelChoiceField配合datalist，表单会自动处理用户关联：

# forms.py
from django import forms
from .models import Customer, User

class CustomerForm(forms.ModelForm):
    user = forms.ModelChoiceField(
        queryset=User.objects.all(),
        widget=forms.TextInput(attrs={'list': 'results', 'class': 'form-control'}),
        label='客户姓名'
    )

    class Meta:
        model = Customer
        fields = ['user', 'cust_notes']

前端只需保留datalist部分，表单会自动验证用户选择并完成关联，无需手动处理ID映射。

内容的提问来源于stack exchange，提问作者JustWondering