About FHLPC

FHLPC · 05-18-2021

The app is connected to a MySQL database. AppSheet doesn’t have auto-increment (and I am not interested in a random UNIQUEID()). I created a database column called MY_ID as primary key set as unique, and auto increment. Every time the user adds a new...

FHLPC · 05-07-2021

I added the Show_If formula to hide the column SCAN_URL CONTEXT(“ViewType”) = “form” The column is still visible, but empty. No need to display an empty column. I need to have this column editable and visible only in the ‘form’ view. And I’d like thi...

FHLPC · 05-06-2021

I checked CONTEXT() and SHOW_IF() resources, but unable to understand or find an example for my case. I have few hidden columns, that I want to show only in specific views. For example: View1 = hide column1 View2 = show column1 How do I combine CONTE...

FHLPC · 05-06-2021

I couldn’t find documentation on the difference between the columns initial value and formulas. Is there a reference link I can read?

FHLPC · 05-06-2021

Is it possible to have a button to open the barcode scanner immediately? Instead of pressing the button within the text field form?

FHLPC · 05-19-2021

Steve: AppSheet is owned by Google. Of course, I wouldn’t be here, if AppSheet wasn’t owned by Google. Did the OP find the customer support email? No. Even though William emailed him. Same happened to me. That’s why customers have hard time finding y...

FHLPC · 05-18-2021

Osama_Hashmi: Need to integrate some advanced authentication features and need to sign up for an Enterprise account. I have used every contact form and email but have gotten no response as to getting an Enterprise account. Any help here? I am trying ...

FHLPC · 05-07-2021

tsuji_koichi: Just created sample app for those who are new to Appsheet and/or on intermediate level to share some of the tricks to build up dashboard with chart etc. using Appsheet Dashboard interactive mode, plus some other tips I introduced in the...

FHLPC · 05-07-2021

Thank you, I found your post. This is exactly what I needed: To hide a column in all views except forms, set the column’s Show_If to: CONTEXT("ViewType") = "form" To hide the column only in form views: CONTEXT("ViewType") <> "form" To show only in se...

FHLPC · 05-06-2021

The option is already on, but the current problem is not solved. Maybe there is a miscommunication gap. I am currently asking for something else. In order to scan, I need to click the SCAN_URL field icon below, which opens the scanner camera. Instead...

My Stats

FHLPC's Bio

Badges FHLPC Earned

Recent Activity

PRIMARY KEY: App connected to MySQL DB > with MY_ID field set as Autoincrement

SHOW_IF - CONTEXT() > not hiding the column, but only the records

Show or hide columns depending on current view

Please, help find instructions on columns initial value vs formulas

QR Barcode action to scan directly? Instead of tapping the form field button?

Re: How the heck do I get an enterprise account

Re: How the heck do I get an enterprise account

Re: Sample App - for those who are beginner to intermediate (Dashboard, Map, Chart etc)

Re: Show or hide columns depending on current view

Re: QR Barcode action to scan directly? Instead of tapping the form field button?