I have two tables(sub sheets) in the sheet , First table’s name is Main Sheet and second table’s name is Sheet2 …Main sheet has 3 columns ID , Name and Birthdate and Sheet2 has ID , Name and Image URL …
I want to make bot which runs daily at 9 am everyday and checks for a birthday if anyone’s birthday has a birthday today and if anyone has birthday today then that bot should update the name and image url in the Sheet2…How can i do this please help with i m new to this …please help
Should be pretty simple, I have outlined the steps below:
Hope this helps.
Step 4 you suggested does not work because year does not match , I have used TEXT([Birth Date], “DD/MM”) = TEXT(TODAY(), “DD/MM”) this condition and have set up the bot as you told but data does not get added/updated to Sheet2…
What should i do?
Oh yeah, didnt think about the year!, probably a much easier way of doing this but you could have 4 virtual columns in your first table with the following formulas, DAY([Birthdate], MONTH([Birthdate]), DAY(TODAY()), MONTH(TODAY()), you can set these to hidden if you don’t want them to show in the main app. For ease lets just call the Virtual Columns Date 1, Date 2, Date 3 & Date 4.
Then the filter in step 4 should now read as follows:
AND([Date 1] = [Date 3], [Date 2] = [Date 4])
How about this: Ifs(text([date],"ddmm")=text(today(),"ddmm"),"birthday")
Why there are two tables? What's the purpose of the Sheet2? What's the URL column for?
I mean, this is quite easy but it doesn't make sense to add the same user with it's ID to another table, it's weird from a RDB perspective
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |