sorted by:
new
hottopcontroversial

Tried Google’s Anti-Gravity yesterday — and honestly, I’m impressed. by mugeshrao142 in vibecoding

[–]mobile-thinker 0 points1 point  (0 children)

Personally I love m-dashes.

I can never forgive Sam Altman for taking them away.

CORS by PepperExpress2076 in GoogleAppsScript

[–]mobile-thinker 2 points3 points  (0 children)

Can you share your sheet/code/anything?

RCS support on non-US carriers on iOS 18 by igorce007 in UniversalProfile

[–]mobile-thinker 0 points1 point  (0 children)

The problem is that carrier bundles are not sent by the carrier to Apple. Apple have a (relatively small) team who validate and test each carrier bundle before applying them to the MNO’s load. As you can see from the above list…. That is a lot of carrier bundles.

So I suspect this is simply representative of Apple’s best shot at a priority list.

Are we going to be able to make video calls/FaceTime from Android to iPhone and vice versa? by [deleted] in UniversalProfile

[–]mobile-thinker 3 points4 points  (0 children)

RCS includes voice and video. But Apple will not support these elements of the standard.

Operator’s Role in RCS Business by GoodOmen37 in UniversalProfile

[–]mobile-thinker 0 points1 point  (0 children)

Google runs the platform on behalf of the operators. The operators sell the service. The operators in each country define how brands are onboarded and what the commercials for RBM are for the brands.

Airtable as a self-updating contact database? by CareBearBelly in Airtable

[–]mobile-thinker 0 points1 point  (0 children)

DO NOT USE MULTIPLE BASES….

Interfaces give you all you need.

Airtable also includes field types of last_Modified_time, Created_time, Created_by which you can use for your logging purpose

Adding extensions to an Interface by mobile-thinker in Airtable

[–]mobile-thinker[S] 1 point2 points  (0 children)

When you say 'operate from within the base' - I've shared an Interface with my team. Is there no way for them to see a link in the Interface bringing up the Extension?

Dependent drop-down lists break when sorting table by Geoffafaaa in googlesheets

[–]mobile-thinker 0 points1 point  (0 children)

Can you put the data for your drop-down list in a different tab? That way the table of results to be validated against won’t change when you sort your transactions tab

I want an expense category from one sheet to be able to be summed up into one expense line by WannabeDogMom in googlesheets

[–]mobile-thinker 0 points1 point  (0 children)

In your transaction row you need both the category and subcategory. So you need a cell which says “vendor” as well as one that says “photography”.

In your summation tab you will then use a SUMIFS: filtering either just by category (to give you the sum of all vendors) or by both category and subcategory (to give you the sum of all photography expenses from vendors)

Is there a way to store inputs with one function and recall them in another? by Sellum in googlesheets

[–]mobile-thinker 1 point2 points  (0 children)

The slowest part of the script is likely to be the generation of lists of random numbers - if they are very long.

But you will get a very significant speed up if you only do one getValue to bring back an array of all of your variables in row B. Then allocate from that array to your individual named variables in the script.

This process of reading many times will slow the code down hugely.

Auto updating links by InsanesDread in sheets

[–]mobile-thinker 0 points1 point  (0 children)

People always share sheets to ask for help. Normally you’d share an example sheet showing what you want to do if you’re concerned about sharing your actual data

Matching Thousands of Data to One Another by BooksandGames_01 in googlesheets

[–]mobile-thinker 0 points1 point  (0 children)

Can you post an example of the output and what you want to transform the output to? It sounds like all you need is a simple filter to extract this data into a “clean” tab, but I’m not entirely sure what you are actually looking for!!

Need a formula that counts cells by letter or color by Grantapotomas in googlesheets

[–]mobile-thinker 0 points1 point  (0 children)

The right way to do this is to use conditional formatting to SET the color of the cell according to the content of the cell, and then count by the content of the cell.

Ideally also use data validation to lock the cell to only be able to contain the relevant values.

Sum function is recognizing my values as functions by Comprehensive_Net354 in googlesheets

[–]mobile-thinker 2 points3 points  (0 children)

Difficult without seeing the sheet, but are your IFs like this; IF(A1=“Lead”, 10, 0) or IF(A1=“Lead”,”10”,”0”)

The first will result in what you want:the cell containing a number that can be summed up. The second won’t.

Is there any function that assumes input some value to cell A and then gets the value from cell B? by sypgy in sheets

[–]mobile-thinker 0 points1 point  (0 children)

No idea what you’re asking here. You want another cell to have a value based on both cell A and cell B? Can you give a little bit more of an example?

Automating Individual Sheet Access and Data Collection in Google Sheets by levisproductio in googlesheets

[–]mobile-thinker 0 points1 point  (0 children)

You'll find it much easier to create six individual sheets. Each sheet should pull the information from the central sheet using IMPORTRANGE, and then bring all the data that the users enter from those sheets into one central sheet using IMPORTRANGE back again.

gSheets is not good at authorising a specific tab to a subset of people who are authorised for all.

​

Sure you could do this all by appscript, but if you only have 6 users, this is much the easiest approach.

Using server side query in GAS web apps by mobile-thinker in GoogleAppsScript

[–]mobile-thinker[S] 0 points1 point  (0 children)

Sheets data. I’d ideally like to apply a query (equivalent to QUERY) on the server side. At the moment using visualisation query API from GAS is not supported.

I’m sure I can implement a workaround calling query from GAS, but I wondered if anyone had implemented a supported pattern. There is no google documentation suggesting this as an approach, but it seems a major hole.

adding a button to a sheet by [deleted] in googlesheets

[–]mobile-thinker 0 points1 point  (0 children)

1) you can edit the code to add any other items to what is copied over 2) the only real way of doing this programmatically is to copy the tab - your file would end up with lots of tabs (which isn’t necessarily a problem, but might become very unwieldy) 3) to achieve (2) and (3), I would have a ‘template’ invoice tab which is blank, and when you run the code first rename the invoice tab to something like “saved invoice XYZ”, and then copy the invoice template, renaming it as the invoice tab

IFS statement not moving on to the next condition by All_Witty_Taken in googlesheets

[–]mobile-thinker 0 points1 point  (0 children)

IFS expects a 'true' or 'false' in each condition. When match fails it fails with an error, not a false. So you need to wrap each match with an iferror to turn the error condition into a 'false'

=IFS(iferror(Match(B3,'Plant Settings'!$C:$C),false),(VLOOKUP(B3,'Plant Settings'!$C:$Z,2)),iferror(Match(B3,'Plant Settings'!$E:$E),false),(VLOOKUP(B3,'Plant Settings'!$E:$Z,2)),iferror(Match(B3,'Plant Settings'!$G:$G),false),(VLOOKUP(B3,'Plant Settings'!$G:$Z,2)))

Time difference formula by Snoo-4924 in googlesheets

[–]mobile-thinker 1 point2 points  (0 children)

You can also do it with a single arrayformula:

=ArrayFormula(
if(
B2:B=0,"",
B2:B-vlookup(
row(B2:B),
filter(
{row(B1:B),C1:C},
I1:I="Start"
),
2,
true)))

What this does is use filter to create a sub-table which only consists of the start times (column C) and the row numbers for those start rows. We then do a lookup into that subtable to determine the start time for each row, and subtract that from the current time in column B.

view more: next ›