Page: https://jds-cvoa.wixsite.com/cvoa/CVOA-Registry
This site is scheduled to go live this weekend and I just loaded up live data. The test data is still there and when I look at a test record it works as it did in testing. However, when I click on a new record it is not getting the username info from the Members dataset.
Did I miss a field in my database during load? If you look at the First Two records displayed, the First record is a Test entry that used a wix generated ID. I properly gets the Name,…etc from the Members Dataset.
When I did the load of live data I assigned a member_number as the ID so that I could RELOAD as needed.
Please Advise ASAP
thanks
JD
I removed the CVOA-Members dataset from the page and added it back thinking maybe that would fix it. Instead it removed all connections. Even the test entry now does not work?
I undid in the Editor until I got it back to behaving as reported initially. Old Member Information is retrieved and ALL new entries (1400) do NOT???
FYI - The problem has been identified. The CSV file used to import the data had trailing spaces on the email address. This prevented the filter on the repeater dataset from finding the owner info!
1 Like
Hey,
Just saw your post now. Great job finding the problem! Don’t you just love stuff like this? 
Yisrael
Thanks Yisrael. I retired from Oracle customer support where I was an Advanced Resolution engineer. I learned a long time ago that code will no arbitrarily mis-behave. When things like this happen is is most always data related. It was obscure in that you could not look at the fields and tell the difference. Only by clicking into the field did I notice the trailing spaces. After manually removing a few and re-testing it proved my findings. Once we reloaded all data the page is working as expected.
Unfortunately, it being a weekend, I logged a frontline support ticket and waited 4 /12 hours. I then logged another requesting a call back. An engineer spent 1 1/2 hours on the phone then told me that this design would not work because a repeater could only connect to one dataset at a time and I would have to use reference fields to make this work!
Just this morning, I received an update from the first support ticket as tollows:
“Elements which are connected to a dataset can only be connected to one at a time. It is not possible to connect an element to numerous datasets.
With that being said, you are able to connect different datasets to different elements. For instance, if you have two elements, you can connect one to one dataset, and one to a different dataset.
If you want to pull data from a different collection, you will need to use the reference field. The reference field allows you to “lookup” fields from another collection and import into the element.”
Again, those guys are misinformed.
JD
1 Like
Hey JD, sorry but my code arbitrarily misbehaves. Regularly. Honest.
This is not a Go-Live show-stopper but I would really like to get it fixed. On this same page, when the members information is displayed it really needs to have the trailing spaces removed. For example: right now for my entry it shows:
Jerry Smith
Deltona FL
Here is my code:
$w.onReady( function () {
let search = ‘1’;
let saved_dash = $w(‘#regDash’);
session.setItem(“#dash#”, saved_dash);
const currentItem = $w(‘#dynamicDataset’).getCurrentItem();
$w(‘#text87’).text = ${currentItem.fname} ${currentItem.lname};
console.log((‘#text87’).value)
});
– It did not work… in preview mode the console log showed “undefined”
Hi,
I didn’t find this code in your page, is this still relevant?
Roi.
This problem has been resolved. This Post is no longer relevant.
Thank You.
JD