I want to view the rows of google sheet matching some criteria

[Anand_S_Dhanaks]

I have a database as google sheet (spreadsheet).
It has some rows and columns.
One of the column is ProjectName which has values like SGRAN,NOFN,LTE etc
I want to create an web app which dipays the rows where column name ProjectName is having the value NOFN.
Please explain how to create such a app in appsheet.
regards,
Anand

[DPM_reports]

First u have to create a slice for the table having the data with the following expression

[ProjectName]=NOFN

and after creating slice, create a view in the UX and select the source table as the slice u just created. now in this view u will see the data as per your need

[Suvrutt_Gurjar]

Some additional references

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

help.appsheet.com

Slice Row Filter Conditions

Explore how to use row filter conditions to build different slices of data.

Relevant Sample App:

https://www.appsheet.com/samples/This-app-shows-how-to-slice-your-data?appGuidString=984a5f04-96f6-4...

[Anand_S_Dhanaks]

Thanks for the help.
I created an app using slice.
I also moved it to deployed state.
How do i run this app?
Please help

[DPM_reports]

if you have deployed the app…make sure you have subscribed to 1 of the pricing plans…or else you would not be able to use app…

If you have download Appsheet from Playstore or Apple Appstore and login to the app using the ID u used to create this app or the invite id u have entered in the appsheet users page…

open the app adn you will the see the app either the my apps section or shared apps if you are using a different id than the one used to create it.

[Anand_S_Dhanaks]

Before deploying,
I want to test my app to know whether it is working or not?
How do i test it?

[DPM_reports]

when u goto appsheet on you mobile using the same id u have created the app, u will see the app in my apps…click on the app u want to test and start using it.

[Anand_S_Dhanaks]

I want to test my web app not mobile app. How do test the web app?

[DPM_reports]

goto users>link> and copy browser link

[Anand_S_Dhanaks]

The view of the slice is not working properly.
it is showing blank.
Why?

[DPM_reports]

can u share a screenshot of the slice

[Anand_S_Dhanaks]

I have taken the screen shot.
How do i share it to you?

[DPM_reports]

attach by clicking as in screenshot below

[Anand_S_Dhanaks]

[Chris_Jeal]

Wrap your column name into square brackets [Process Area Code]

Also, be sure that you have a ‘View’ created that is pointing to your slice.

[Anand_S_Dhanaks]

Thanks for your example app.
Similarly i want a example app for using forms.
I want to display the slice of data using the given inputs provided in the form.
I want to take user inputs from the form and use it to create a slice of data and i want to display the slice of main table to the user.
How do it do it in Appsheet.
Please explain or send me an example app using forms.

[Suvrutt_Gurjar]

https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266...

[Anand_S_Dhanaks]

Please give me your mail-id. I will make you coauthor.
Please demonstrate like how to take input from form and display the slice of data as output.

[Anand_S_Dhanaks]

Thanks for the help.
I want to use form in my application.
Hwo to write an expression where i can select and display the rows mtaching a column (Project Name)
having the value selected by the user (for Ex:EAIS,SGRAN NOFN etc)
I want the form the show all the possible values of Project Name like SGRAN,EAIS or NOFN for the user select one of them.
How to do that using form.?
How to write thr filter expression for that?

[DPM_reports]

for this you have to enter a expression in data validity of the column header where it refers to only those values as referenced by the Project Name.

For instance Project Name is A

u want the next entry selection to show 1, 2, 3

If Project name is B

u want next entry to show 4,5,6

Do u want this type of thing

[Anand_S_Dhanaks]

No,
Project Name is a column in google sheet and like this there are other columns like Date of Recording, Process Area Code, Context of the lesson etc.Projet Name can have text strings as SGRAN,NOFN, EAIS etc(They are different projects).I want the app to present these values(SGRAN,NOFN,EAIS) to the user to select one of them,
When user selects one of them,The matching rows with the values corresponding to all the columns including Project Name,Date Of Recording,Process Are Code, Context Of the lesson should be displayed to the user.

[DPM_reports]

can u share a screenshot of the google sheet… of the table with headers only and some sample data if possible so that i can help u better

[Anand_S_Dhanaks]

I have uploaded the screenshot of google sheet, From this j have made a table called Blr

[Anand_S_Dhanaks]

This is the screenshot of UX(view) i have created

[Anand_S_Dhanaks]

This is the image of data slice created by me to filter the matching rows

[DPM_reports]

your expression maybe wrong…pls check…is the Project name column same as the value in Project name…

[Anand_S_Dhanaks]

I have attached my slice screenshot.
But it is not generating the proper view.
Please check.

[DPM_reports]

that’s because the expression is wrong. it should be as below, and make sure source table is selected properly

[Process Area Code]=SDDUT

when writing an expression, the column header should be in closed square brackets.

[Anand_S_Dhanaks]

I created the view in which the rows matching condition Process Area Code is SDDUT ,are to be displayed.
Here all the columns are not displayed.
I have uploaded the screenshot.
Please suggest what is wrong.

[DPM_reports]

please check the source table in UX to check if you have selected the correct slice

[Anand_S_Dhanaks]

When i click on view data button it is shwoing the required(filtered) rows.
But when i share a app to another user(through mail-id) and when they open the app in browser.
the view is not showing all the columns of the filtered rows.
What is wrong here

[DPM_reports]

if its possible pls send me an invite to your app and make me a co-author i will look and sort your issue,after that you can delete my invite

[Anand_S_Dhanaks]

what is your mail-id?

[DPM_reports]

dpmreports4449@gmail.com

[Anand_S_Dhanaks]

it is a company’s data, this i can not share with you.
Thanks for your help

[DPM_reports]

no problem…what u can do is remove all data except headers and share it for me to help you…later on you can add data

[Anand_S_Dhanaks]

I want to store the google sheet in my local PC not in the google drive.
Will the application work with the data stored in my PC?
How to make it work with the data in my PC?
Also i want to use forms where user can submitt data, in my case project name and seach and display the matching rows which have the given project name.
Basically the user want to given inputs for project name and process area code and display the matching rows as a result. How to do this in the app?

[DPM_reports]

Application will not work for data stored in local PC.

in form you can get matching row as result using expression, the expression will depend on the data for which if u share screenshot of table and the result you are expecting i can tell u the expression.

[Anand_S_Dhanaks]

[Anand_S_Dhanaks]

Help me with the espression to filter the rows matching ProjectName as EAIS.
How to take input from user using form?
Pease explain.