表单数据无法保存至GCP BigQuery问题排查求助

已搭建GCP BigQuery实例，通过Wix托管网站向指定表写入数据。目前Wix与GCP连接正常，通过Wix GUI可手动编辑记录，但代码执行时无报错，数据却未写入BigQuery表，推测缺少提交记录变更的步骤。

获取itemID的代码 #

let item = $w('#dataGCPOperational').getCurrentItem();
saveData(item._id);

核心逻辑代码 #

export function saveData(itemID){
  let userEmail = currentMember.getMember().then((member) => {
          return member.loginEmail;
          
      })
  let instagramHandle = $w('#inputInstagram').value
  console.log("instagramHandle " + instagramHandle)
  let market = $w('#dropdownMarket').value
  console.log("market " + market)
  //let optIn2023 = $w('#checkbox2023OptIn').value
  let howManyYrs = $w('#inputYearsParticipated').value
  console.log("howManyYrs " + howManyYrs)
  let howManySixteen = $w('#inputYearsCompleted16').value
  console.log("howManySixteen " + howManySixteen)
  let participatedBefore = $w('#checkboxParticipatedBefore').value
  console.log("participatedBefore " + participatedBefore)
  let sixteenBefore = $w('#checkboxCompleted16Before').value
  console.log("sixteenBefore " + sixteenBefore)
  let exclProgressBoard = $w('#checkboxExcludeFromLeaderboard').value
  console.log("exclProgressBoard " + exclProgressBoard)

  wixData.get("gcpOperationalDB/tblSTMParticipantData", itemID)
  .then(item => {
      item.email = userEmail
      item.instagram = instagramHandle;
      item.market = market
      item.numYearsParticipated = howManyYrs
      item.numYearsSixteen = howManySixteen
      item.participatedBefore = participatedBefore
      item.recordedSixteen = sixteenBefore
      item.excludeFromLeaderboard = exclProgressBoard
    })
    return $w('#dataGCPOperational').save()
    .then(() => {
        console.log("Item updated successfully");
    })
    .catch((err) => {
        console.log("Failed to update item: " + err);
    });

}

预期写入的变量 #

let instagramHandle = $w('#inputInstagram').value
let market = $w('#dropdownMarket').value
let howManyYrs = $w('#inputYearsParticipated').value
let howManySixteen = $w('#inputYearsCompleted16').value
let participatedBefore = $w('#checkboxParticipatedBefore').value
let sixteenBefore = $w('#checkboxCompleted16Before').value
let exclProgressBoard = $w('#checkboxExcludeFromLeaderboard').value

问题排查与修复 #

你的代码存在三个关键问题，导致数据无法写入：

1. 异步操作顺序错误：wixData.get是异步操作，但你在它的then回调外直接执行$w('#dataGCPOperational').save()，此时修改后的item还没生效，save的是原始数据。
2. userEmail处理错误：currentMember.getMember()返回Promise，直接赋值给userEmail会得到Promise对象而非实际邮箱地址，需要用await或嵌套then处理。
3. 未正确更新数据集的当前项：你修改的是wixData.get返回的item，但没有将修改后的item同步到页面的数据集$w('#dataGCPOperational')中，直接调用save不会保存你的修改。

修复后的代码 #

export async function saveData(itemID){
  // 用await获取用户邮箱，确保拿到实际值
  const member = await currentMember.getMember();
  const userEmail = member.loginEmail;

  const instagramHandle = $w('#inputInstagram').value;
  const market = $w('#dropdownMarket').value;
  const howManyYrs = $w('#inputYearsParticipated').value;
  const howManySixteen = $w('#inputYearsCompleted16').value;
  const participatedBefore = $w('#checkboxParticipatedBefore').value;
  const sixteenBefore = $w('#checkboxCompleted16Before').value;
  const exclProgressBoard = $w('#checkboxExcludeFromLeaderboard').value;

  try {
    // 获取数据项并修改
    const item = await wixData.get("gcpOperationalDB/tblSTMParticipantData", itemID);
    item.email = userEmail;
    item.instagram = instagramHandle;
    item.market = market;
    item.numYearsParticipated = howManyYrs;
    item.numYearsSixteen = howManySixteen;
    item.participatedBefore = participatedBefore;
    item.recordedSixteen = sixteenBefore;
    item.excludeFromLeaderboard = exclProgressBoard;

    // 将修改后的item同步到页面数据集
    $w('#dataGCPOperational').setCurrentItem(item);
    // 保存数据集的修改
    await $w('#dataGCPOperational').save();
    console.log("Item updated successfully");
  } catch (err) {
    console.log("Failed to update item: " + err);
  }
}

关键修改点说明 #

• 使用async/await处理所有异步操作，确保代码执行顺序正确，避免Promise嵌套混乱。
• 先通过wixData.get获取并修改item，再用setCurrentItem将修改后的item同步到页面数据集，最后调用save提交变更。
• 正确获取用户邮箱，避免将Promise对象赋值给item.email。

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