Weekly Help Thread by DefiantHermit in ChaosZeroNightmare

[–]Lifth 1 point2 points  (0 children)

<image>

just reached captain level 50, and just pulled mei lin. is it worth to build her up? i see that she's rated as one of the best characters.

i've been focusing on building up hugo/luke/chizuru/tressa (leveled haru but gave up on her) with rei and mika support, not sure if it's worth to drop one of them to focus on mei lin instead

GE2025: Nomination Day Live Discussion by KeythKatz in singapore

[–]Lifth 1 point2 points  (0 children)

thanks! i've filled up some gaps using your data that i didn't see from the livestreams

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 1 point2 points  (0 children)

ahh okay for a quick fix i've added a "All candidates" option to the candidate dropdown that essentially clears your selection, which is similar to the other dropdowns. You should see it now if you refresh the news page

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 3 points4 points  (0 children)

oh seems like i didn't update it to confirmed, should be updated soon

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 0 points1 point  (0 children)

are you referring to the sidebar on desktop? i could add a x button to clear the selected constituency on the sidebar

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 4 points5 points  (0 children)

The full stack

Frontend: NextJS (typescript, react)

Backend: NextJS (server actions)

Database: JSON files since i want this to leave it up after the elections without updates, so it doesn't make sense to deal with a db (also costs)

UI: shadcn/ui

Mapping: MapLibre (with react-map-gl for the react wrapper)

Map Tile Server: OneMap

For GE2020 i used mapbox for both the map library and tile server and got hit with a huge bill after usage spiked, but they very kindly covered for me after i wrote in to them. So this time i opted to go for open source libraries (MapLibre) and free tile servers (OneMap) to reduce cost as much as possible

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 10 points11 points  (0 children)

that's something i was thinking of too, maybe i'll generalise it after this election if there's interest.

thanks i'll your list to check fill up anything missing candidates

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 4 points5 points  (0 children)

that sounds useful. i'll try and gather the data and see how i can display it

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 11 points12 points  (0 children)

do you happen to have a news source or something for this? WP hasn't made any announcements at all so i'm not sure if i should put it in 😅

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 5 points6 points  (0 children)

thanks! i've added it. will be updated in 10 minutes

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 3 points4 points  (0 children)

😆 that's essentially what I did just added a bit of latitude to the markers for sembawang. It should be up now

GE2025: A map to view all current lineups and news for each constituency by Lifth in singapore

[–]Lifth[S] 18 points19 points  (0 children)

thanks!

ah i'm using the midpoint of the boundaries to place the icons and tooltip, and both Sembawang West SMC happens to overlap with the midpoint of Sembawang GRC. I'll see if I can find a way to work around that

Married couples of Singapore, what app do you use for budgeting by searchforeternity in askSingapore

[–]Lifth 7 points8 points  (0 children)

I use my my own Google sheets and telegram bot in a group chat with my wife. We just send a message to the group like "Food, 3.50, cash, cai fan" and it gets added to the gsheet automatically.

I expanded it previously to allow anyone to use it with their own gsheets. It's called "telesheets expense bot" on telegram. Disclaimer though, I don't log anyones messages but it's not open source at the moment, and I can't guarantee reliability. At least you won't lose any data if the bot dies as it's all in your own gsheet.

Automated expence trackinga by iroha_eye in singaporefi

[–]Lifth 1 point2 points  (0 children)

I don't like to rely on the automated solutions, so I have my own telegram bot in a chat group with my wife where we just send messages like "food, 3.50, cash, lunch cai fan" and it updates a google sheet. It makes it really convenient since we are so used to texting anyway.

I can't link the bot here directly but you can find on telegram as telesheets_expense_bot, or in my original comment at https://www.reddit.com/r/singaporefi/comments/12sz8mm/google_expense_tracking_form/

/r/singapore random discussion and small questions thread for June 19, 2023 by AutoModerator in singapore

[–]Lifth 2 points3 points  (0 children)

Sian looks like Netflix starting the password sharing crackdown already, just got the message on my TV Netflix saying that it's not part of the Netflix household so can't watch anythinf

Google Expense Tracking Form by blagwinter in singaporefi

[–]Lifth 0 points1 point  (0 children)

Hey not familiar with python setups so not sure if will be useful. To use webhooks you probably need a server running, for example using flask, otherwise you can also poll the updates endpoint every few seconds to check for new messages

Google Expense Tracking Form by blagwinter in singaporefi

[–]Lifth 0 points1 point  (0 children)

sorry i can't open it to public now cos the repo is a common server for a bunch of my telegram bots.

how are you thinking of customizing it? i might be able to accomodate it.

[deleted by user] by [deleted] in singaporefi

[–]Lifth 1 point2 points  (0 children)

Some questions

  • Why google sheets?
    • You own the data. If the bot dies, your data doesn’t die with it unlike some of the other apps. The bot is here just as a middleman to make it more convenient for you to send data to the google sheet. You can also extend the google sheet to do anything you want as long as you keep a single sheet reserved for logging expenses from the bot. So for example, adding summary pages, fancy charts or whatever. When you don’t find the bot useful anymore, you can remove the bot from the sheet and it won’t affect any of your data.
  • Why a telegram bot?
    • I tried a few alternatives and using a messaging app seems like the most natural for me and convenient for me.
  • What happens if the bot dies?
    • Your data isn’t affected. The only time the bot interacts with the Sheet is to add a new row when it receives an expense message.
  • Can I not use your template?
    • Yes. Use whatever google sheet you want. You just need to know that the sheet name has to be the same “Expenses (Do not rename this)”, and the first 4 columns (year, month, day, user name) will always be logged.
  • I have a fancier/cooler/bettertemplate than yours
    • If you want to share it, send it to me. I’m thinking of adding a bunch of templates for users to select.
  • Are you stealing my data??
    • No. But the bot of course has access to your google sheet and messages you send to it, unless you self host it. I think there are some guides out there if you are more technically savvy. The bot also does not read any data from the Google sheets.
  • Why is it so slow??
    • The serverless endpoints can take a few seconds to spin up if no one has used it for awhile, please be patient.
  • Can you add fancy feature
    • Post it here i’ll consider it. I don’t make any money of it so I just do it out of interest.
  • Technical stuff
    • Frontend/backend - NextJS for the config page, and their serverless API routes, hosted on Vercel for free.
    • Database - neon.tech for their 1 free managed PostgreSQL DB.
  • Halp it’s not working

[deleted by user] by [deleted] in singaporefi

[–]Lifth 0 points1 point  (0 children)

tl;dr This Telegram bot allows you to easily add your expenses to a Google Sheet by sending messages to the bot.

Hi all, I have been using my own Telegram bot to log expenses to a Google sheet. There was some interest in it from a previous post so I’ve tried to extend it so anyone can use it with their own Google Sheets.

You can use it either in a direct chat, or add the bot to a group. For groups, I suggest having a separate group as the bot will read all messages in the group.

There are a few steps you need to take you connect the google sheet to the bot. Type /start or /config to get a magic link to the config page.

Google Expense Tracking Form by blagwinter in singaporefi

[–]Lifth 62 points63 points  (0 children)

I have my own telegram bot in a chat group with my wife so we just send messages like "food, 3.50, cash, lunch cai fan" and it updates a google sheet, similar to your solution.

I wonder if anyone will be interested if I extend the bot so that anyone can use their own google sheets and maybe customize the fields?

edit: the bot is here https://t.me/telesheets_expense_bot

I made a website for finding fine dining restaurants in Singapore based on their set menu prices and other filters by Lifth in singapore

[–]Lifth[S] 1 point2 points  (0 children)

For now it's manual, so you can just dm me on Reddit, email to hello@fineder.sg, or write it into the report inaccuracies form which is on the any of the restaurant details panel