So glad I found this thread. I'm trying to display all plans for a currently logged in user. The following code shows one plan (since I couldn't figure out how to list all plans, I listed the most recent one). I haven't tried putting a repeater or table on the page to show all. (I'd need help with that since you normally connect the data collection where the current member orders reside. CurrentMemberOrders is not listed as an available data collection to connect.) This is what I have in on Ready: wixUsers.currentUser.getPricingPlans()  //put offset in parenthesis; to go to 2nd plan, put 1.             .then((pricingPlans) => { let currentPlan = pricingPlans[pricingPlans.length - 1]; let planName = currentPlan.name; let qprice = currentPlan.price; //let benefits = currentPlan.benefits; //let sdate = currentPlan.startDate; let eDate = currentPlan.expiryDate;                 $w('#PlanName').value = currentPlan.name;                 $w('#Price').value = currentPlan.price;                 $w('#ExpirationDate').value = currentPlan.expiryDate.toDateString();             });         wixPaidPlans.getCurrentMemberOrders() ////put offset in parenthesis; to go to 2nd plan, put 1. //function getCurrentMemberOrders([offset: number], [limit: number]): Array             .then((pricingPlans) => { let currentPlan = pricingPlans[pricingPlans.length - 1];                 $w('#PlanStatus').value = currentPlan.status;             }) This is what is displayed for me (I'm a member and an Admin). If I can show all plans, I'm hoping I'll see the plan I paid for as a member. And this is our second year for plans so I want members to see both years. Below is what shows for a test user. I bought a $0 plan so I didn't have to actually pay for something in my test: If there is a paid plan, will the amount show up? Is there a way to display $0 plans? Thanks in advance for any guidance you can provide!

This works GREAT! Took only a few minutes. Now I'm trying to figure out how to filter the dataset based on the user's inputs BEFORE saving the URL's. I have 100 pages of galleries and the user can select by year or title keyword. It's this subset of items I want to capture before going to the category page. What could I change to capture URLs in the dataset based on what the user has selected only? Would I add code within my filter functions instead of on ready? This is my page code. Thanks in advance for any help here. (I was delighted to find the article!) import wixData from "wix-data"; import { local } from 'wix-storage'; const linkField = "link-photogalleries-title"; $w.onReady(function () {     $w("#dynamicDataset").onReady(() => { const numberOfItems = $w("#dynamicDataset").getTotalCount();         $w("#dynamicDataset").getItems(0, numberOfItems)             .then((result) => { const dynamicPageURLs = result.items.map(item => item[linkField]);                 local.setItem('dynamicPageURLs', dynamicPageURLs);             })             .catch((err) => {                 console.log(err.code, err.message);             });     }); }) //search by school year export function Year_change(event) { let searchyear = $w("#Year").value;     $w("#dynamicDataset").setFilter(wixData.filter()         .contains("schoolYear", searchyear));     wixData.query("PhotoGalleries")         .contains("year", $w('#Year').value)         .find().then((results) => {         }); } //search by title function title() { let searchtitle = $w("#titleSearch").value;     $w("#dynamicDataset").setFilter(wixData.filter()         .contains("title", searchtitle));     wixData.query("#dynamicDataset")         .contains("title", $w('#titleSearch').value)         .find() } export function titleSearch_change(event, $w) {     title(); } //clear search criteria export function clear_click(event) {     $w("#titleSearch").value = "";     $w("#Year").value = "";     $w("#dynamicDataset").setFilter(wixData.filter()); }

I have a media gallery on each item in my data collection. Using a repeater, how can I display the media gallery attached to each item? The editor won't let me add the media gallery to a repeater (which is the perfect way to do it). Maybe there's a trick to this. If I put the media gallery below the repeater, only the first media gallery of the filtered set is displayed. I can filter on a particular record which will show that record's gallery, but I want my users to be able to scroll through the records and have the gallery change record by record. I tried putting a button that would make the gallery collapse and expand, but that doesn't work either.

@GOS The data set is Read & Write (see the screen shot above). What I meant to say is the settings for the Date Picker and text date items are set to read only. Sorry for the confusion! I have a test user set up in my example so I am testing it all live, nothing in the sandbox. The page is not visible to my users on a menu. The permissions on the data set are good because I use the dataset in another live page. When this problem is fixed (hopefully), I will be rolling out a version of the example on the Input Repeaters page where the user will be able to add new items, and edit or delete existing items. My current live page is clunky because I didn't know how to do that when I started in September. The other page code is irrelevant because the problem is showing itself whether I have other page code or not. Initially support was reviewing my live page but I decided to set up a test page so I was sure there were not issues with my code causing the problem. My other issues were posted on other threads (and thanks to those who have helped me resolve). Thanks for reading my posts!

Thanks. Yisrael suggested I post a new item about it.

@Yisrael (Wix) Will do. Thanks for checking in!

@Yisrael (Wix) See my response above (edited March 18 - sorry I clicked the wrong reply). I have code and a video of what's going on. I created a box that expands/collapses and am using input items and add new items.

@Yisrael (Wix) I added a box collapsed on load to allow room for the date picker calendar to pop up. When the user clicks the datePicker, the code expands the box and the calendar pops up. I have added a close button to close it but if the user doesn't notice it and clicks back on the date picker field, the space and the close button remain. I'd like it to collapse the box automatically whenever the calendar closes but I haven't been able to do this automatically. Go to this link for a little video of the behavior of the problem. (Probably too big to include in this post) https://www.youtube.com/watch?v=AqVwwlxJf0s code relevant to this video $w.onReady(function () { $w("#datasetTable").onReady(() => {}) //to expand box for calendar when user clicks on datePicker $w("#datePicker1").onClick((event) => { let $item = $w.at(event.context); $item('#box1').expand(); }); }); //Close button to collapse box for calendar export function Close_click(event) { let $item = $w.at(event.context); $item('#box1').collapse(); } // collapse box when user changes date export function datePicker1_change(event) { let $item = $w.at(event.context); $item('#box1').collapse(); } NEED HELP Is there a way to collapse the box whenever the calendar collapses without the user having to click the workaround "close" button? (watch the video if this doesn't make sense). Thanks in advance if anyone has a suggestion. By the way, Yisreal's example above seems to be working now. I used it to create the page I show in the video on this post. The page is his method to add new items, edit input fields, and delete fields. My only problem (which is being reviewed by support) is that sometimes, the datePicker field is empty when I click Show more entries. A real head scratcher! I know the dates are in the data collection because I can display a date in a text field even when the datePicker shows it is blank.

@Yisrael (Wix) I was hopeful with your examples to use the date field to bind a text input field to it and code it so the date was valid. The examples were cumbersome for me (a newbie, non-programmer). So I went back to trying to fix the date picker problem (which is actually a bug to me because drop down boxes work in narrow repeaters, why not the date picker?) SOLUTION TO DATE PICKER NOT WORKING IN A REPEATER If you're trying to use a date picker in a narrow repeater, normally it won't fit in the row. After trial and error to collapse and expand a box within the repeater to hold the calendar, this is my working code: import wixData from "wix-data"; $w.onReady( function () { $w("#datePicker6").onClick( (event) => { let $item = $w.at(event.context); $item('#box1').expand(); } ); } ); export function input52_click(event) { let $item = $w.at(event.context); $item('#box1').collapse(); } Within the repeater container, I created a box large enough to display the calendar popup and set the box property to "collapsed on load". The on ready function above expands the box for the current item only when the user clicks the date picker. The click event for input 52 (the next field which is required) collapses the box so the repeater goes back to the original size. If only I can solve the problem with support where dates appear blank (sometimes) when I load more records even though there is a date in the data collection items. This happened before I implemented the collapse/expand for the calendar (and is still a problem).

A Datepicker in a repeater that isn’t tall enough to show the calendar doesn’t work because the calendar doesn’t pop up. thank you for your suggestions. There were many postings but I didn’t find one that showed how to create a plain text box with an example like you included. I will try this and will post my results when I get it working. Many thanks for a speedy reply!

Hello, I have a similar problem. Parsing error with onReady function - I think I'm close! SITUATION: I am trying to filter a data collection by the login user's email address. As Admin I have added the initial records to the collection and need the ability for my members to update their address information as needed. More than half of our members may not edit their information nor go online at all but I need everyone's info for our roster (which is displayed in a repeater on a page visible to Members). Many of our members are elderly and are not computer savvy. As admin, I add the initial record when I approve the member at registration Here is the code I am using to fill an input field with the logged in user's email address and then trying to use that to filter the data collection which is Read/Write so they can then edit it (on a Member page). I have a parsing error and can't figure out what token is missing to make the code work. I hope someone can take a quick look to help. import wixUsers from 'wix-users'; import wixData from "wix-data"; $w.onReady(function () { $w("#dataset5").onReady( () => { //DocentRoster data set let user = wixUsers.currentUser; let userId = user.id; let isLoggedIn = user.loggedIn; let userRole = user.role; user.getEmail() .then( (email) => { let userEmail = email;  $w('#input40').value = userEmail; $w("#dataset5").setFieldValue("loginEmail",$w('#input40').value); let filter = $w("#input40").value; $w("#dataset5").setFilter(wixData.filter().contains("docentEmail", filter)); wixData.query("DocentRoster") .contains("docentEmail",$w("#input40").value) .find() .then(res => { $w('#box35').expand(); } ); Box35 has the fields I want the user to be able to edit (address, phone, comments, preferences, etc.). All are from the DocentRoster set up as Read/Write with no filter. Thanks in advance if anyone can spot what's I've done wrong.

@poolshark314 I'm a newbie and I didn't understand your code. I found my method by reading several other posts and trial and error. Sorry I can't help with your code.

I finally figured this out after several attempts! (above example signed in as Llaa Sjma). Final WORKING code! import wixData from 'wix-data'; import wixUsers from 'wix-users'; let user = wixUsers.currentUser; let userId = user.id; let isLoggedIn = user.loggedIn; user.getEmail() .then( (email) => { let userEmail = email; } ); $w.onReady(() => { Sum_amount(); }); let having = wixData.filter().eq("_owner",userId) export function Sum_amount(){ wixData.aggregate("MilesHoursLog") .group("_owner") .having(having) .sum("hours","sumHours") .sum("miles","sumMiles") .run() .then( (results) => { $w('#input1').value = results.items[0].sumHours; //display total in input field at bottom of table $w('#input2').value = results.items[0].sumMiles; //display total in input field at bottom of table }); } I ended up using group and having instead of filter (highlighted in red above). Simple once I tried it based on another post. I had wanted to filter the dataset by logged in user before aggregating. (Seems like it should be super easy, similar to being able to filter the dataset on the page.) I hope this helps some other poor soul stumbling through Wix without coding experience. I am SO excited because we are collecting volunteer hours and miles by member and they can now see their own totals after they have entered them.

Any solutions here?

@anthonyb (or anyone else who knows how to filter the rows before aggregating the totals. This is my current code: import wixData from 'wix-data'; import wixUsers from 'wix-users'; let user = wixUsers.currentUser; let userId = user.id; let isLoggedIn = user.loggedIn; user.getEmail() .then( (email) => { let userEmail = email; } ); let searchOwner = user.id.value; let filter = wixData.filter().eq("_owner",searchOwner); $w.onReady(() => { Sum_amount(); }); export function Sum_amount(){ wixData.aggregate("MilesHoursLog") .filter(filter) .sum("hours","sumHours") .sum("miles","sumMiles") .run() .then( (results) => { $w('#input1').value = results.items[0].sumHours; //display total in input field at bottom of table $w('#input2').value = results.items[0].sumMiles; //display total in input field at bottom of table }); } No errors, but the filter is not working. The aggregated totals are for all records in the collection instead of for those of the logged-in user. Any help would be greatly appreciated.

@george It doesn't work if my member is an admin or a forum moderator. That's weird! And it only works as read-only. I need it to be read-write. Thanks for posting your solution. (I've learned a lot about using Wix through this forum due to generous folks like you.) Unfortunately, unless any member (admin, moderator, blogger or whatever) can read and write to the dataset (created by admin), it's not going to do what I need it to. You gave me a glimmer of hope but I wish Wix would make it easier to work with data collections. My workaround is to have two datasets - one I create as an admin, the other created by the user. But I can't edit the user-created dataset until they add it (then it is filtered by the owner ID, not the login email). It makes the work flow awkward when they first become a member. I'm working around the limitations but fear it will be hard to train someone else. :(

I was so excited to see this post but I can't seem to make it work. In order to reference the Members Private Dataset in the filter, I had to first add that dataset to the page. Then, I added the login email filter to my custom dataset (I already had the login email field in my dataset) as you described but when I publish it and log in as a member, I don't see any information. I have set it up as a Read-Write data set so users will be able to edit their own information that I have added via the dashboard when they become a member. (Although I also tested to see if Read-Only would work and it doesn't.) Could you show a screen shot of your page and of the settings for your data sets? I seem to be missing something.

I tried a different approach to filtering. Back to total hours for the data collection, not just those for the logged in user. :( import wixData from 'wix-data'; import wixUsers from 'wix-users'; let user = wixUsers.currentUser; let userId = user.id; let isLoggedIn = user.loggedIn; user.getEmail() .then( (email) => { let userEmail = email; // "user@something.com" } ); let searchOwner = user.id.value; let filter = wixData.filter().eq("_owner",searchOwner); $w.onReady(() => { Sum_amount(); }); export function Sum_amount(){ wixData.aggregate("MilesHoursLog") .filter(filter) .sum("hours","sumHours") .sum("miles","sumMiles") .run() .then( (results) => { $w('#input1').value = results.items[0].sumHours; //display total in input field at bottom of table $w('#input2').value = results.items[0].sumMiles; //display total in input field at bottom of table } ); } Any ideas on how I can filter the data collection by owner for aggregating hours and miles for the logged in user?

@anthonyb Thanks for getting me closer (I think) Heath H-M and anthonyb. But now my totals are zero (before they were for the whole data collection. I hope my mistake is little but I can't figure out what's wrong (no errors in Preview). import wixData from 'wix-data'; import wixUsers from 'wix-users'; let user = wixUsers.currentUser; let userId = user.id; let isLoggedIn = user.loggedIn; user.getEmail() .then( (email) => { let userEmail = email; // "user@something.com" } ); const filter = wixData.filter().eq("owner",user.id); $w.onReady(() => { Sum_amount(); }); export function Sum_amount(){ wixData.aggregate("MilesHoursLog") .filter(filter) .sum("hours","sumHours") .sum("miles","sumMiles") .run() .then( (results) => { $w('#input1').value = results.items[0].sumHours; //display total in input field at bottom of table $w('#input2').value = results.items[0].sumMiles; //display total in input field at bottom of table } ); }

UPDATE: I just realized user Id in the private member data is the same as owner ID in my collection. @anthonyb I want to do the same filter as I would on a dataset I'm displaying on the page (where logged in user's Owner ID (user ID) matches the Owner ID in the data collection). (I tried referencing the filtered data collection in the aggregate function but it wasn't valid.) This is my page code (I am a beginning coder, BTW). I'm getting totals for ALL records, not the filtered ones. UPDATED CODE (8/28): import wixData from 'wix-data'; import wixUsers from 'wix-users'; let user = wixUsers.currentUser; let userId = user.id; let isLoggedIn = user.loggedIn; user.getEmail() .then( (email) => { let userEmail = email; // "user@something.com" } ); let searchOwner = user.id.value; let filter = wixData.filter().eq("_owner",searchOwner); //I can't figure out why this isn't working $w.onReady(() => { Sum_amount(); }); export function Sum_amount(){ wixData.aggregate("MilesHoursLog") .filter(filter) //wouldn't this use the filter I referenced above? .sum("hours","sumHours") .sum("miles","sumMiles") .run() .then( (results) => { $w('#input1').value = results.items[0].sumHours; //display total in input field at bottom of table $w('#input2').value = results.items[0].sumMiles; //display total in input field at bottom of table } ); } Thanks in advance!