امروزدخترم رابردم دندانپزشکی .یکی ازهمکاران قدیمی به اسم خانم شریفی رادیدم خوشحال شدم ،راستش برای من فرقی نمی کنه که خاطره خوب ازهمکارام داشته باشم یانه وقتی بعدازمدتهااونهارامی بینم خوشحال میشم،بعدرف...
ادامه مطلبامروزدخترم رابردم دندانپزشکی .یکی ازهمکاران قدیمی به اسم خانم شریفی رادیدم خوشحال شدم ،راستش برای من فرقی نمی کنه که خاطره خوب ازهمکارام داشته باشم یانه وقتی بعدازمدتهااونهارامی بینم خوشحال میشم،بعدرف...
ادامه مطلبامروزدخترم رابردم دندانپزشکی .یکی ازهمکاران قدیمی به اسم خانم شریفی رادیدم خوشحال شدم ،راستش برای من فرقی نمی کنه که خاطره خوب ازهمکارام داشته باشم یانه وقتی بعدازمدتهااونهارامی بینم خوشحال میشم،بعدرف...
ادامه مطلبVote count: 0 static data is working with filters but having problem in dynamic data filtering Any and all help is appreciated. Thanks! asked 55 secs agoVikrum Bhalla Let's block ads! بخوانید...
ادامه مطلبVote count: 0 I would like to show only partners that a user is assigned to, I have a list of partners as below: { "_id" : ObjectId("57c1cfa16c9cdc9007b26f8a"), "__t" : "Partner", "createdAt" : ISODate("2016-08-27T17:36:33.648+0000"), "updatedAt" : ISODate("2016-08-27T17:36:33.648+0000"), "user" : ObjectId("57c1cf776c9cdc9007b26f7b"), "descr" : "asdkalksdasdasd", "name" : "partner1", "__v" : NumberInt(0) },{ "_id" : ObjectId("57c1cfe76c9cdc9007b26fd2"), "__t" : "Partner", "createdAt" : ISODate("2016-08-27T17:37:43.784+0000"), "updatedAt" : ISODate("2016-08-27T17:37:43.784+0000"), "user" : ObjectId("57c1cf776c9cdc9007b26f7b"), "descr" : "sdfdsfsdf", "name" : "partner2", "__v" : NumberInt(0) }...
ادامه مطلبVote count: 0 I am working on a UWP app that has data bound in a ListView. I have been trying to find a way to collapse (hide) a control when there is no data. For example, i made a simple version of what i am doing:...
ادامه مطلبVote count: 0 I'm new to Android development. My project has an existing website hosts by Squarespace platform, users can register by filling a form in the website and it will send these information to Google sheets(which is a default function for Squarespace). I am developing an android app that both existing users and new users can register via app. To get the existing user information I need to pull the data from Google sheets, and for new users I need to update their information in the Google sheets. My trouble is how to coect to Google sheets in Android Studio? Most software has this service charges, is there any free or open source can do this? asked 36 secs agoZhining Qi Let's block a...
ادامه مطلبVote count: 0 I have a simple script on my personal server that retus JSON data. I have a Google Sheet with a list of useames, and I want to be able to somehow run a script on a useame cell to update only the values in that row, on demand. Is there a way to trigger an apps script that will call my API and update only the specific row with a given useame? I don't know where I would even start with this. asked 24 secs agoVaindil Let's block ads! بخوانید...
ادامه مطلبVote count: 0 I have been attempting to create an automated lost and found search system using cognito forms, zapier and google sheets. When a form is submitted, zapier creates a new row in the "inquiries" worksheet. I have been able to create formulas that use the input information to search the second worksheet "event data" for matching data but using an ARRAYFORMULA doesn't perform with 100% accuracy. I have used CountIFs to indicate that submitted data cells have a matching counterpart in the database, but I don't think these would be horizontally linked. Despite the unlikely event that multiple pieces of information would occur, perhaps a script or additional arguments would work. When ...
ادامه مطلبVote count: 0 I thought this would be simple, but I can't figure it out. If someone types "completed" into A1, I want it to send an email to a specific email address. Initially I set up a "completed" button, but it doesn't work on mobile. So I now just need it to send me an email when someone types in the word "completed". asked 2 mins agoChris Norris Let's block ads! بخوانید...
ادامه مطلبVote count: 0 Here is my example sheet. This is the formula that is not working: =QUERY(IMPORTHTML("https://ct.thecmp.org/app/v1/index.php?do=match&task=getMatchResultsDetail&MatchId=12504&EventId=1&AwardId=1","TABLE",1),"SELECT Col1, Col2, Col4, Col5, Col6, Col7 where Col2 'Names!G:G'") I would like to import the table, but only for the entries that match the names in column G of my Names Sheet. asked 1 min agoJake Let's block ads! بخوانید...
ادامه مطلبVote count: 0 Is there a way to get the result from the Example sheet Columns J:K using a single function? I.e. is there a way to count unique / disctinct values within QUERY function, or any other single function that would create a pivot-like set of data with two columns? In the example sheet I have a set of data, which I need to group by one column and count unique values in the other one. There's a workaround there, but it involves two formulas plus another one that would sort it properly (data set is growing and rows get added, so sorting manually is not the best option). Query function (or, my knowledge of Query function) doesn't seem to be able to count unique values, so it's not work...
ادامه مطلبVote count: 0 Sorry for the somewhat long title, but I was told to be as specific as possible. :D My problem will require some explantion. So, I have 2 spreadsheets files ("Konverteringstabeller" and "Tee Posen").In "Tee Posen" I have a sheet named "Scores MIK" (golf scorecard and my name).In "Konverteringstabeller" I have sheets with conversion tables for multiple golf courses, but if one works, all should. What I need is to find out what course handicap I would get if my golf handicap is "HCP 26,0" (as shown in File 2 Picture), and in this case that result should be 29 (not visible), but you should get the point.(example: golf hcp 10 would result in course hcp 11, because 10 is between 9,9...
ادامه مطلبVote count: 0 I am trying to have the google forms on our website auto-notify us when a user completes the form and then retu the data that they entered in a concise email. I do not like the way google notifies you it simply links to you the form to view the response. I searched online and found this code: function sendFormByEmailPrayer(e) { // Remember to replace XYZ with your own email address var email = "admin@communionchapelefca.org"; // Optional but change the following variable // to have a custom subject for Google Docs emails var subject = "Prayer Form Form Submitted"; // The variable e holds all the form values in an array. // Loop through the array and append values to the body. v...
ادامه مطلب