Hi all. I’m VERY NEW to AppSheet and have created an internal app for the purpose of stocktaking for our business with the help of an external source. I hope someone can assist me with 3 outstanding issues on my created app and its related purpose.
#1 In my search bar, there is a filter icon. After pressing this filter icon, it brings up columns and then search bars for each column category. I would like to know a) how to modify these columns (I’ve tried but must be in the wrong area), b) how to change it from a search button inside the filter to more of a format similar to Excel’s filtering (actual data).
#2 I have a field (PartName) in a form that is showing radio buttons, even though a dropdown option is selected.
#3 The purpose of the app is to show inventory items and add counts for 3 locations directly into the 1st table (the Inventory List). The 2nd tab is for items not appearing in the main inventory list (unarchived items or missing items altogether). The 3rd tab’s purpose was supposed to be an audit trail/record of each item recorded. However, I was only able to get it to record the missing items. When I tried to include the 1st tab’s records, only records taken from the first page referencing to DH came across - DK & WS were not copied across to this table. This has since been removed, so only missing items are being recorded. Preferably, if I can get it to work, all records will appear in this summary table.
I’ve taken screenshots of what I think may be relevant in my platform and preview. Please let me know if I need to provide more information and the best way of doing so.
Thank you so much for your help!
Hi @cdhamo
1. If you want to modify the display in the search filter, go to the table column, check or uncheck it if you don’t want it to be displayed in the search menu.
2. If you want the name in the dropdown to be appropriate, activate the label in the desired column (ref column).
Try checking the following link, it might be useful for you. Learning AppSheet from YouTube and the AppSheet Community (Tutorial Links)
Faça um dashboard com todas as sua visualizações. Aí o ícone da lupa vai pesquisar em todos os campos de todas as tabelas
Create a dashboard with all your visualizations. Then the magnifying glass icon will search all fields in all tables.
HI @cdhamo ! Welcome to AppSheet and this Community! I think you’ll find us all very helpful in navigating the AppSheet ecosystem.
The columns that show in the Filter list are listed only if they are marked Searchable. We have no control over the order of those displayed columns. The values to filter by are derived from the data itself - i.e. it only includes the filter options for values that actually exist in the dats for columns that have choices/choice lists.
If you mean applying a Filter on each column header, that’s not an available feature. You can apply Filtering to more than one column which achieves the same results.
That is how single-selection dropdowns are displayed. Using radio buttons is a common input control for this type of selection method.
If you wish to select MULTIPLE items from the dropdown, then you want to change the data type for the column to EnumList. If this column is a REFERENCE to another table, then you would use EnumList but then set the “Base Type” of that column to REF.
If I understand correctly, 1 and 2 are basically the same information per item just that some are archived or missing. Instead of having two tables, use one table and add a column to represent the availability of the item - e.g “Available”, “Missing” or “Archived”. This is much simpler than trying to manage two tables.
The audit trail should definitely be in a seperate table. You might want to make it a Child of the Items table which will automatically give you a list of Audit rows per Item. BUT, you can still view the Audit table by itself to see ALL audit records together.
I hope this helps!
