Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Inventory Tracking

Featured Replies

Hi,

I am trying to create a simple inventory tracking solution for our shop. I have started with the template provided in FMP9 and working from their. i have added quantity fields for a count of how many items i have.

Id like to create a layout which has 3 (or more?) colums. The colum would populate with all the items in a catagory as selected from a drop down list of categoriesavailable at the top of each colum. (If i dont select a category, no list will apear in the colum)

Beside each item in the colum would be a field for a number. This would be the quantity of items i take out of inventory of that item. So, i can go down the list, put the numbers next to all the items i take, in each colum, then click CHECK OUT. This will then update the quantity for each item. (If i enter no number then no change to the quantity will be made) this allows me to checkout many items from many categories at the same time.

the process will be the same for CHECK IN...just adding to the quantity rather than subtracting.

This is not connected to customers or anything, it is a simple "How many do i have" list, so just tracking numbers... except that i often check out many items from many categories all at once, so want to make it fast and easy.

Any thoughts on how i would acheive this would be very much appreciated. Im not sure ware to start...

Would using a portal be the first step... display the items in a portal then use creative scripting to add or remove items from the inventory count???

thanks!

Edited by Guest
After thought

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.