Shopping List

[robinsiebler]

Someone expressed and interest in this, so I am uploading it. Thanks to Sam for all his help!

This is a simple Shopping List. There are 3 forms. The actual shopping list form, a category form and a products form (which contains the items to populate the shopping list with).

Adding an item to the shopping list is done via a Siri Shortcut (see attached screenshot).

The expected input to the shortcut is <number> item. If a number is not provided, 1 is assumed. For example, you could say ‘3 Peaches’ or ‘Heavy Cream’.

When an item is added to the shopping list, it will see if it exists in the product form. If it does, the item will be also given a category (if it exists). If the item does not exist, it will be added to products, but it will not have a category (this will have to be added manually).

Items are sorted in the Shopping List alphabetically, by category.

There is only 1 script ‘Get Item From Clipboard’ and it does all the work.

Enjoy!

Attachments:

You must be logged in to view attached files.

[robinsiebler]

I added a script (Combine Items) to combine duplicate items into one.

function combineItems() {
	// Combine duplicate items into one item

	var dict = {};
	var records = form.getRecords();
	var item_id = 'fld-097c3d751c854b1fb4b528238d48b2c4';
	var quantity_id = 'fld-285e2c9de4924b7fbba2fd8311ceb625';

	for (var i = 0, count = records.length; i < count; i++){
		item = records.getFieldValue(item_id);
		quantity = records.getFieldValue(quantity_id);
		record_id = records.getId();

		if (dict[item] === undefined) {
			dict[item] = [quantity, record_id];
		} else {
			dict[item][0] = dict[item][0] + quantity;
			form.deleteRecord(records);
			rec = form.getRecordWithId(dict[item][1]);
			 rec.setFieldValue(quantity_id, dict[item][0]);
			form.saveAllChanges();
		}
	}
}

combineItems();

[robinsiebler]

I added over 200 products to the products database and also added the ‘Combine Items’ script

Attachments:

You must be logged in to view attached files.

[Roger Cuthbert]

Just what I have been looking for. It’s good to see people still using TapForms. Thanks.

[robinsiebler]

I fixed some bugs and added a notes field. I also added another 100 products to the products form. In addition, I updated the Shortcut to prompt for a note (see screen shot). However, Siri is stupid! If you say ‘No’ when you are prompted for a note, Siri bails on the entire script! So, instead of saying ‘No’, say ‘Later’ and you will not be prompted for the note.

I should mention that you have to manually create the Shortcut using the attached screenshot as a guide. I have no clue how to share a shortcut outside of the Apple ecosystem.

Attachments:

You must be logged in to view attached files.

[Roger Cuthbert]

When I add items to the shopping List form by selecting them manually from the dropdown that picks from the Product Form it doesnt bring over the category into the shopping list form.

Not sure if it does when using Siri though.

Any thoughts on how to fix that?

[robinsiebler]

I never intended it to be done manually (since I originally wrote this for my wife, who would do it via dictation). Let me look into it!

FWIW, it works just fine via the shortcut.

[Roger Cuthbert]

I’ve tried with Siri and it still creates just the item without a Category at my end ?

[robinsiebler]

And the item you are adding is in the Product form and has a category? If so, could you try this? Add the item in question to the clipboard and just run the script ‘Get Item from Clipboard’. Let me know what happens.

[Roger Cuthbert]

I added Naan manually and the shopping list record did not add the category.

I created a shortcut as you suggested. Added Naan to the clipboard and ran your script and the category is added correctly.

[robinsiebler]

SO just to verify:
1. If you manually add an item to the Shopping List, the categopy is not added.
2. If you manually run the script, the category is added.
3. If you run the Shortcut the category is added.

If all of that is true, I think all that I have to do is a add a field script to the Shopping List form that will update the category.

I will try that and get back to you.

[Roger Cuthbert]

I’m in the uk. I will check in the morning. Thanks so much for helping.

[robinsiebler]

Fixed!

Attachments:

You must be logged in to view attached files.

[Roger Cuthbert]

Excellent. Thanks. Tested and working.

I would add just one more thing, a checkbox field (in my trolley) to the shopping list form to tick when you have the item. And if the filter is showing unticked items the user will only see items still left to buy.

Great set of forms thanks so much.

[robinsiebler]

Ok, I added the checkmark field. In addition, I added a Search Filter for unchecked items and a script you can use to remove checked items.

Attachments:

You must be logged in to view attached files.

[robinsiebler]

Minor code cleanup and fix for Siri stupidity

Attachments:

You must be logged in to view attached files.

[Yvette M]

How come I can’t import this into Tap Forms? I’m on an iPhone with updated Tap Forms. Thanks

[Brendan]

Hi Yvette,

The Shopping List is a full database document. So you will need to probably download it to your Mac, unzip it, then AirDrop it to your iPhone. Or if you download it to iCloud Drive you can then launch Tap Forms and open any document, then go to Tools > Backup & Restore, then tap on the Download button. Find the file in iCloud Drive (or wherever you stored it), then select it to download it to Tap Forms. It’ll appear as a backup. You can then tap on it and then tap on the Restore Backup button.

It will appear as a separate document in your main Documents area. So you’ll need to close the currently opened document to see it.

Thanks,

Brendan

[Yvette M]

I didn’t know to press the restore button. Got it now. Thanks!

[robinsiebler]

I fixed the annoying bug (blank entries in the Product form). The Products form now has 460+ items!

Attachments:

You must be logged in to view attached files.

[Author]

Posts