selecting rows by critiera which is input by user

AppSheet AppSheet Q&A
1

Afternoon guys, i have a column in my table called Location Code which has a 5 figure number in it.

what i would like to do if possible is in a view that i get the option to type in the first 2 digits and it pulls everything under those two numbers.

user input would be example = 31 and the output from this should be 21 rows as there 21 items stored under the location code. or if you wanted to look at 31 to 34 it would return 36 rows.

Location code is made up of 5 digits eg 31001 - first number is 3 is the cupboard number (5 altogether), second number is 1 which is the shelf number and last three digits is the item number i need to be able to view everything for the first two digits only.

hopefully this makes sense.

thank you all for your time - Jase

2
  1. Have a table listing these codes.
  2. Make your “Location Code” column a Ref pointing to that table.

Nothing more.

3

Thank you for your help. The Location Code will be new as new items are added to the cupboard, or a item moves into a different cupboard etc.

Is there another way i can do this please that you can help me with.

Appreciated your help

4

Create a Slice with formula like [Location Code]=[User Input Location Code Column Name]

Use this slice in a view

5

To have a correct answer, you need to elaborate your case. Are you looking this for a specific view? Do you need this for a dropdown on a form view? How would you like to type it and where? Or could it be that you add an additional column with the 2 first digits and you just group a table view and users can open that group?

6

@jase72 ,

This would be much faster because there won’t be any expressions involved.

7

  1. Yes, you can move the items from one cupboard, shelf to another by changing the location code for the items.

  2. Yes, you can create N number of new locations codes, items. it does not matter.

  3. Question to be answered is how are you going enter the input ?

It could be 21, 22, 24 - 30 anything … So express your idea and need here as screenshots or Gifs etc for fulfilling your requirement..

  1. Have you ever tried of using filter/search option given in detailed or table view in the top of appsheet UI ?
8

I need it as a new View. I need the user to be able to type in what ever two digit code that they need to check.

The location code is 5 digits long so i may need to look at more than one shelf in one cupboard. As the first number is the cupboard and the second number is the shelf.

9

Hi Jaichith,

I am very new to this product so not sure what everything is at the minute.

jase72_0-1718094330476.png
jase72_0-1718094330476.png1886Ă—1013 121 KB

So this is the data pulled from a sheet that i set up. So at the moment it shows everything that is in stock which will be added to or adjusted.

I then created a view which looks at flammable stock only which there is a limit which can be stored in a cupboard due to COSHH Regs.

jase72_2-1718094581572.png
jase72_2-1718094581572.png1886Ă—1013 113 KB

So i am trying to create a view where 31, 32 etc can be typed in and it would show all the rows for the first two digits. Hopefully i have explained a little better.

10

How many different codes (2 first digit) do you have?

11

i have 4 cupboards and 1 container. So it will go from 1 to 5. the cupboards have 4 shelves each and the container will be 1 shelf.

Example - 11, 12, 13 & 14. 21,22,23 &24. this will be the same for 3 & 4. container will be 51

12

Then you could have an additional either normal or virtual column for the first two digits. Then Group the table view with that column.. the view will have then 17 rows to select and the user would not need to type anything.

13

@AleksiAlkio If his cupboards and containers are a few grouping may help. In future if the firm has 100s for cupboards it would be difficult for him.

Is there any option to enter input in the form field like digits and ranges etc usually done in print page selection 1,2,3 , 6 to 15 ( this enables him to type digits and range which saves time without typing each digits if some digits are left in the sequence)

14

Well.. that we don’t know.

15

I was hoping if this worked i was going to use the same idea for something else which would have a lot more shelves with lots of boxes …