We are creating a member contact form that allows users to provide current contact info as well as identifying any other companies that might belong to their group. The contact information is provided on the first page, then the user clicks a button to pull up the second page to enter other companies. I had the second page running a query in the onReady event to grab the company that was entered on the first page and load it into a table that is not directly connected to the dataset. Then, as additional companies are added on the second page, it adds each one to the table through code. In Preview, it works completely as expected. In Live, it doesn’t display the onReady query result at all, just an empty table. Subsequent companies that are entered through the form DO appear in the table, but about six lines down, with lots of blank space above. I don’t know why the behavior is different from one to the other. I have synced my sandbox data with the live data, so it’s not that. Any thoughts would be appreciated. Here’s the code on the second page:
import wixData from “wix-data”;
import {session} from “wix-storage”;
// For full API documentation, including code examples, visit http://wix.to/94BuAAs
$w.onReady( function () {
let origComp = session.getItem(“sessioncomp”)
$w(“#origCoName”).value = origComp;
let origNaic = session.getItem(“sessionnaic”)
$w(“#naicNumber”).value = origNaic;
let origGroup = session.getItem(“sessiongroup”)
$w(“#groupNumber”).value = origGroup;
wixData.query(“MemberGroups”)
.eq(“groupNumber”, origGroup)
.find()
.then(res => {
$w(“#groupTable”).rows = res.items;
}
);
});
export function addCoButton_click(event) {
let compname = $w(“#relatedCoName”).value
$w(“#dataset1”).setFieldValue(“companyName”, compname);
let naicno = $w(“#naicNumber2”).value
$w(“#dataset1”).setFieldValue(“memberNaic”, naicno);
let groupno = $w(“#groupNumber”).value
$w(“#dataset1”).setFieldValue(“groupNumber”, groupno);
let rows = $w(“#groupTable”).rows;
rows.push({groupNumber: groupno, memberNaic: naicno, companyName: compname});
$w(“#groupTable”).rows = rows;
}
export function searchButton2_click(event) {
wixData.query(“OIGAMembers”)
.eq(“fldNaic”, $w(“#naicNumber2”).value)
.find()
.then(res => {
if (res.totalCount === 0){
$w(“#relatedCoName”).value = “Company Not Found”;
} else {
let coname = res.items[0][“fldCoName”];
$w("#relatedCoName").value = coname;
}
});
}