3D Reference in Google Sheet

3D referenceing is a feature available in Microsoft Excel A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data,…

Android App Development : Using Google App Scripts API

Some usefull links are in Google Official Documentation https://blog.heron.me/executing-functions-using-the-apps-script-api-47c822681e5d Good class to use as starting point https://ctrlq.org/google.apps.script/docs/guides/rest/quickstart/android.html Phase 1 : instatiate Credential static final int REQUEST_ACCOUNT_PICKER = 1000; static final int REQUEST_AUTHORIZATION = 1001; static final int REQUEST_GOOGLE_PLAY_SERVICES = 1002; private static final String PREF_ACCOUNT_NAME = "accountName"; private static final String[] SCOPES = { "https://www.googleapis.com/auth/drive"…

PHP json encode errors

"Malformed UTF-8 characters, possibly incorrectly encoded" Detection use json_last_error() $mainJsonString = json_encode($mainJsonObj); //echo "<pre>".print_r($mainJsonString, true)."</pre>"; if ( json_last_error() !== JSON_ERROR_NONE) { die( "error parsing data: check if symbols like single quote has come inside the data to parse"); } use JSON_THROW_ON_ERROR try { $mainJsonString = json_encode($mainJsonObj, JSON_THROW_ON_ERROR, 512 ); } catch (\JsonException $exception) { die($exception->getMessage());…

Android App Development : Google Sign In/Login

Integrating Google Sign-In into Your Android App Try Android Sample Project Configure a Google API Console project and set up your Android Studio project Integrating Google Sign-In into Your Android App Additional Scopes OAuth2 involves authentication and authorisation Authentication and Authorization frontend and backend workflow OAuth2 workflow Source of the above image is linked to…

Android App Development : Nuances

Points Covered Layout Type Observer and Observable Activity Click Listener MVC Material Design Components App Bar, Action Bar & Tool Bar Layout Types Official Doc Linear Layout LinearLayout is a view group that aligns all children in a single direction, vertically or horizontally. Relative Layout RelativeLayout is a view group that displays child views in…

Android App Development : Quick Tips

Points Covered Data Types Async Tasks Logging DialogBox WebView SuppressLint Data types Array Equivalent // declaring a list of integer private List List; // reserving the space for list elements List = new ArrayList(3); ArrayList nameValuePairs = new ArrayList(); nameValuePairs.add(new BasicNameValuePair("Your_var_1", value)); nameValuePairs.add(new BasicNameValuePair("Your_var_2", value)); Map<String, List> assocArr = { ‘title1’: [‘haha’, ‘hehe’], ‘huhuh3’: [‘hihihi’,…

Android App Development : Activity Life Cycle

Activity Life Cycle Official Documentation Activity class provides a core set of six callbacks: onCreate(), onStart(), onResume(), onPause(), onStop(), and onDestroy(). The system invokes each of these callbacks as an activity enters a new state. Orientation Changes Nice Tutorial on Handling Orientation Changes Fragment Life Cycle Normal Behaviour If you rotate your device when you…

Android App Development : Fundamentals

App fundamentals Official Documentation Official Tutorails Manifest and Gradle Manifest what is gradle in android studio? Android Studio uses Gradle, an advanced build toolkit, to automate and manage the build process while letting you define flexible, custom build configurations. Each build configuration can define its own set of code and resources while reusing the parts…