Hey guys ,I am working on a calendar db and basically I have ‘‘date’’ , ‘‘price’’ and ‘‘blocked (yes/no)’’ for 365 days. So 365 entry points, that will be editable by users .Solution 1 that I have tried is to schedule a wf on a list and that costs around 720 WU per calendar. Solution 2 is to create a default 365 days calendar than copy that list to the users date_price list and 99 item copy costs 200 WU. Is there any optimized way for copy that template db to the users or create one , any other approach works as well .
You definitely shouldn’t be copying 365 days onto a list field on a data type, especially if it’s the User data type (which is loaded every time a page is loaded).
No , 365 days date_price list is under resource_calendar data type which is a satalite data table , and it has date_price_holder and inside that there is a list so , even I call resource_calendar created by current user , list of dates won’t call . I got everything covered all I need is to not create 365 days calendar for each user . Do you have any ways for it ?
But if you think that this calendars will be created yearly it is 365 days for 12 months so , monthly it comes to 30 WU per user , per month , it is almost nothing but I don’t have that option too , to break my WU consumption as yearly
yes, I would not copy the template data structure as it doesn’t sound optimized
No reason to have 365 entries to try and correspond to dates of the year, since you know, every year has different dates because of the year component, so you would be needing to do this each year which is unnecessary.
Please share more about what the real goal of the feature is…is it to show a list of prices that are available on a specific date or show a single product is that is available for a specific date.
Dates should not be saved as a data type…they should be generated on the fly for creating the calendar…lots of free plugins for that.
Lot of different approaches for calendars and displaying values associated with dates, but depends on the user case and the ultimate goal of the feature.
Hey Boston , hotel room type structure , a resource calendar that has these two main options 1) Ability to block or change the price of that date 2) Owner will be able to see the booking options inside of it and select which one it likes. Notes : currently creating date%prices couples and adding to a data holder table is costing (Yearly 400WU + 200WU respectively ) , paginating on monthly basis costs 16WU per month (rg search cost) , if I use custom states to pass the booking rg values , it costs 5 WU . Very similar to this https://www.youtube.com/watch?v=rtHLO_GYlBA&ab_channel=Airbnb
maybe have the data type that is holding the price and date combinations in a list on the page somewhere, like a custom state or in a plugin that lets you store values as a list. Then have your calendar use dates as the datasource. Then in the RG that is your calendar, have the price be displayed via a text element with a dynamic expression that is referencing the stored values of date/price combination and filtering that list by constraining against the current cell’s date.
Also, restrict the list holding the date and price combination to the dates associated with the current view of the calendar…and most importantly, consider not showing a full year calendar and just stick to month to month as most users will not need a full year view, and you can take that advice from somebody who once had 8 different condos on airbnb and also owned and operated a backpacker hostel with 50 dorm beds and 6 private rooms - never once did I look at a full year view of a calendar on any booking platform I used.
Bro wow come work with me , The setup is this , I run a javascript to get list of dates (monthly view ) , than I search for date/price couples (created by user·365 days) that are in the date range of that date list , than in separate rg there is bookings filtered by date range also , when I click a button I send those booking list to a state (to save WU) .I have date prices(rg) , and inside date price , I have bookings when clicked opens bookings contains in that range , also if you click the holder you can adjust prices.It is very complicated to tell
Click the link mine is the same.
1 Like
This topic was automatically closed after 70 days. New replies are no longer allowed.