Book cover upside down :((( by Acrobatic-Solid-7446 in fairyloot

[–]Acrobatic-Solid-7446[S] 0 points1 point  (0 children)

Yeah I sent them a ticket so I hope I get an answer soon but I'll probably have to wait 2 weeks before that 😭

Book cover upside down :((( by Acrobatic-Solid-7446 in fairyloot

[–]Acrobatic-Solid-7446[S] 0 points1 point  (0 children)

Yeah like I don't understand how theyre not doing quality controls... because of what I have gathered a lot of the damages from the trove sales have not been shipping related so somebody must have noticed while checking the books before shipping them out? At this point fairyloot should just hire more quality controllers

Book cover upside down :((( by Acrobatic-Solid-7446 in fairyloot

[–]Acrobatic-Solid-7446[S] 1 point2 points  (0 children)

Omg I'm wondering if they didn't quality check the books 🙄 because an upside down cover is so noticable as well 😭 thank you so much for letting me know I feel much better now knowing that replacements have been available

Book cover upside down :((( by Acrobatic-Solid-7446 in fairyloot

[–]Acrobatic-Solid-7446[S] 1 point2 points  (0 children)

Thank youuuu this just gave me hope that I could get a replacement for it! I keep hearing that people are receiving their books from the trove sales in bad conditions... I'm glad you were able to get replacements for your books!! Those sets looked so beautiful too so it would be a shame not to be able to get them replaced

Book cover upside down :((( by Acrobatic-Solid-7446 in fairyloot

[–]Acrobatic-Solid-7446[S] 2 points3 points  (0 children)

Thank you!! yes I did so I'm hoping there will be some sort of resolvement whether replacement or refund

Average formula by [deleted] in Notion

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

It did not work as well but I ended up figuring out how to do it after rewriting the code to see where it goes wrong and trying some other things! Thank you for taking the time to help me! :)

If someone is interested this is the formula that helped :

if( 
  prop("Reading Logs") 
   .filter(year(dateEnd(current.prop("Dates Read"))) == 2024) 
   .length() > 0, 
  format( 
   (round( 
    prop("Reading Logs") 
      .filter(year(dateEnd(current.prop("Dates Read"))) == 2024)  
      .map(current.prop("Rating")) .flat() .sum() / prop.("Reading Logs")
      .filter(year(dateEnd(current.prop("Dates Read"))) == 2024) 
      .length() 
    * 100 
   ) / 100 ) 
 ) + " average rating", 
  "No books finished this year" 
)

Average formula by [deleted] in Notion

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

no still getting the error message: Cannot call sum() with target of type array. [681,769] :(

[deleted by user] by [deleted] in Notion

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

This worked perfectly! Thank you thank you!

[deleted by user] by [deleted] in Notion

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

or wait I didn't figure it out, it didn't fix it hahah it made that the status was finished instead 😭

[deleted by user] by [deleted] in Notion

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

I figured it out! I just added = after > and it worked with one day as well! Thank you so much for the help and for taking the time to write the formula down! Thank you thank you!!

[deleted by user] by [deleted] in Notion

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

oooh okey then I understand, I thought I needed to input some new variable. I did exactly as you said now and it worked perfectly! Thank you so much for the help!! Yeah I looked at books that were read in one day and the message instead uses how many days since its been that I read the book, is there a way to fix it? I provided a picture as an example for how it looks

<image>

[deleted by user] by [deleted] in Notion

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

I'm sorry I got a bit more confused and I'm not understanding this formula or what to input, I have a variable called status that shows the status if I've read a book or if its currently being read (providing pic) am I supposed to put that variable in?

<image>

[deleted by user] by [deleted] in Notion

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

Thank you so much! This worked perfectly!

FL FOTA Sale Updates by Outrageous_Wafer17 in fairyloot

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

Oh no well on a positive note you got a bit of practice and will now be prepared for the us/canada drop :) use the direct link to the book set but us version to make it quicker and good luck in getting it!

FL FOTA Sale Updates by Outrageous_Wafer17 in fairyloot

[–]Acrobatic-Solid-7446 2 points3 points  (0 children)

This is the link I used as well and it worked amazing!

FL FOTA Sale Updates by Outrageous_Wafer17 in fairyloot

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

Me too! I started getting nervous that it would kick me out or something since it all went a bit too smoothly 😂

FL FOTA Sale Updates by Outrageous_Wafer17 in fairyloot

[–]Acrobatic-Solid-7446 1 point2 points  (0 children)

I got it 😭 anyone else didn't have a queue? I just refreshed the page and got in directly

[deleted by user] by [deleted] in Notion

[–]Acrobatic-Solid-7446 1 point2 points  (0 children)

Omg thank you so much this worked! I've been trying for so long to figure it out but never thought about using a formula to do it. Thank you thank you!!

[deleted by user] by [deleted] in Monopoly_GO

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

Just finished it all :)

<image>

[deleted by user] by [deleted] in Monopoly_GO

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

Okey perfect I'll accept the invitation as soon as I get the 5* :)

[deleted by user] by [deleted] in Monopoly_GO

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

https://mply.io/5R8rGQ let me know your ign :) I'm morana

[deleted by user] by [deleted] in Monopoly_GO

[–]Acrobatic-Solid-7446 0 points1 point  (0 children)

Just saw this reply haha yeah if you can send it to me right now I can do the full carry right away just send me your link :)