I am puzzled because I have been able to add the user’s login email to one of my data collections (where there is one record per user). But now it isn’t working on my new data collection that has multiple records per user (logging hours and miles). At the top of the page, they can add new entries, one by one. In the middle of the page, they can edit individual entries by paging through them until they find the one they want to change. At the bottom is a view-only table of all entries. A bit clunky but I haven’t been able to figure out a better way without going into extensive coding (I am not a programmer).
Here’s the page:
I have 3 versions of the data collection defined to do this (first is Write only for adding new record, second is Read-Write where user uses Next and Previous to page through entries, third is Read only for the table). The second two are filtered by logged in Owner ID. All of this works great.
When the user chooses an activity (required), their user login email displays in input field 31 (below the Activity drop down at the top of the page) which is linked to the data item LoginEmail (which is for my info as a web admin so I know which OwnerID goes with which member’s email). I can see the user’s email on the screen when I select the activity, but when I submit the entry, it is not being added to the data collection.
Here’s the code:
import wixUsers from ‘wix-users’;
import wixData from “wix-data”;
//When user enters or changes Activity (which is required), their logged in user email is added to the input31 field. Input31 field is connected to the data collection field LoginEmail. Why isn’t it updating when user clicks Submit?
export function dropdown1_change(event) {
let user = wixUsers.currentUser;
let userId = user.id;
let isLoggedIn = user.loggedIn;
let userRole = user.role;
user.getEmail()
.then( (email) => {
let userEmail = email; // “user@something.com”
$w(‘#input31’).value = userEmail;
}
);
}
//Can’t remember why this is here but without it, user can’t add new entries.
export function text219_click(event) {
$w(‘#group1’).expand();
}
//Refresh data sets when adding new entries (to be able to edit or see them in the table)
export function button7_click(event) {
$w(‘#dataset3’).refresh()
$w(‘#dataset1’).refresh()
}
I’d sure like to know what I’m missing.
PS: The other thing I’m trying to figure out is how to total the hours and miles for the user in the table. I’m stumped! Have tried several things but to no avail.
