Search Results for 'script'

[Mark Moran]

I purchased the Mac version from your site and the iOS version from the app store about 2 months ago.

“If you purchased Tap Forms 5 within the past 6 months of installing Tap Forms Pro, you’ll be given an offer to use Tap Forms Pro for 6 months for free. Plus a two week trial period when you choose the yearly subscription option. As long as you have Tap Forms 5 installed on your device, Tap Forms Pro will detect that and will display the offer.”

I don’t see the offer?

• This topic was modified 6 months, 1 week ago by Mark Moran.

Attachments:

You must be logged in to view attached files.

[Chi Pai]

Dear Brendan,

Thanks for developing Tap Forms. I have had many critical personal databases in Tap Forms, and those databases are very important for me. Therefore, with the new subscription model, I am concerned if I will still be able to at least access or open my databases, in case I must terminate my subscription any time in the future?

Chi

[Brendan]

Hi Mike,

Hey no worries. I’m very happy you worked it all out now. And I’m really thrilled that you’ve been using Tap Forms happily for 15 years! That’s just one year after I started building it!

Yes, Tap Forms Pro comes in a bundle for macOS + iOS for a single subscription. You can choose that option on the paywall screen.

Thanks!

Brendan

[sean]

I have been a Mac User since 1989. There are a few programs that have been around from the start. Over the years I have accumulated a core of must have programs for my Mac environment. I migrated here from Bento. Tap Forms is a keeper. I have had no problem paying for all the versions I need (iPad, iPhone and desktop, etc.). I say all of that to say I understand the subscription model BUT you will need to develop a perpetual license at some point for the Pro version. I will have no problem paying for whatever versions or licenses I need (at a decent price). Keep up the good work.

• This topic was modified 6 months, 1 week ago by sean.
• This topic was modified 6 months, 1 week ago by sean.

sdg

[Mike Cainn]

Hi Brenden,

Thank you so much for taking the time to test this issue. Your simple instructions worked perfectly. The issue I was having seems to be from trying to delete the iCloud data from within the iPhone settings, instead of the app itself. The delete from iCloud button in the app is greyed out, so I was using the iPhone settings instead. I didn’t realize that you have to disable iCloud sync first for the button to become active.

I would like to apologize for the cynical thoughts I was having with the new version and support for Tap Forms 5. After using this app regularly for over 15 years and never having a problem, I should have known better. Nothing I own has given me the value I have gotten from this app for what I paid originally.

When I posted this question, I didn’t realize that Tap Forms Pro was already out. Can I use the Pro version on my Mac, iPad and iPhone with one subscription?

Thanks again for your quick help,

Mike

[Stanley VanDruff]

And now you are going to a subscription model. Syncing has always been broken and I have lost a lot of work because of it. Now you are going to abandon Tap Forms 5 without ever fixing it or adding new features. A $50 app becomes $50/year and the pro version probably won’t ever get upgrades either.

[Brendan]

Hi Shane,

When you subscribe to the Yearly option, it includes a 14 day free trial. You can cancel your subscription before the 14 days is up anytime and you still get the 14 days to try it out.

Thanks,

Brendan

[Oliver]

I have two databases that I wanted to manage in one tool. On the one hand, this is my didactic lesson planning for lecturers, for which I used an external SaaS tool on the web. I was intending an idea of building a solution using PHP or Python Django. But the longer I used this technical solution in django, the more I realized that I was drifting away from the actual benefit, which was to help with planning; I was coding around. I tested dozens of solutions until I came across Tap Forms. Tap Forms offers me a simple GUI, flexible field design, meaningful structure of relations and possible extensions with Javascript (such as auto update of fields, etc.). I’m not finished yet, but I’m gradually getting closer to using it.
The second database are notes and records of coaching and therapy sessions as a therapist. Tap Forms does not keep this personal data for me as a web solution, but encrypted on my Mac. Just as I believe it should be with such personal data.
The third thing I like is the friendly interaction of the community. And Brendans great work of course.

[Hans]

You are right: the weeks before, everything worked fine: after I have clicked on the icon with the globe, the APP opened and not the browser version of maps. I recognized that many people searched for a solution for that, however, for other apps.
Unfortunately, I am a newbie in Tap Forms, so the first thought is always: Damn, what have I done wrong (with a focus on JavaScript) ? ;-)

[Brendan]

Glad you got it working. With the Calculation field, it can get pretty tricky to follow all the nesting. IF / THEN / ELSE, and so on.

That’s why when things get complicated like that, using a Script is much simpler I feel.

[Brendan]

You will be able to use Shortcuts to call out to scripts to fetch data from Tap Forms Pro, so maybe that’s a avenue for you to integrate with these other system.

[JScottA]

Take the following information carefully as it from the Tap Forms 5 Assistant (a custom GPT that is not supported by Brendan…he is the go to expert on everything). However I hope it helps and gives Brenda more time for finishing the next version of the database!

The issue described in the forum post — trying to navigate from a child form (e.g. “Tasks”) to a parent form (e.g. “Projects” or “Clients”) using a script button — is understandable but currently not supported in the exact way desired due to Tap Forms’ internal handling of navigation and view rendering.

Here’s the technical reasoning and current limitation:

🔍 Explanation:

When you use a URL like:

var theURL = “tapformz://record/view/[db-id]/[form-id]/[record-id]”;
Utils.openUrl(theURL);

It can navigate to a record, but only within the same form where the script is executed. If used to target a record in a different form (like a parent form), Tap Forms will select the record in the background but not update the current view — exactly as the user described.

This behavior is confirmed by Tap Forms’ current URL scheme and scripting limitations, which do not allow cross-form navigation with visible view switching.

⸻

❌ This doesn’t work:

var theURL = “tapformz://form/view/[db-id]/[form-id]/”;
Utils.openUrl(theURL);

Even though the intention here is to just open the parent form’s record list, Tap Forms does not act on this kind of URL in a user-visible way.

⸻

✅ Workaround:

Unfortunately, based on current documentation (including scripting APIs at Tap Forms Scripting 101), there is no direct, supported way to programmatically navigate from a child record to a parent record’s detail view via scripting.

The only partial workaround is to instruct users to manually click on the linked parent record shown via the inverse relationship field in the layout.

⸻

✅ Suggestion for Better UX:
• Include a Link From Form field in the child form layout (enabled via “Show Inverse Relationship”).
• Style it clearly so the user understands it’s clickable to reach the parent.

⸻

If Tap Forms updates their scripting API or URL schemes in the future to support this kind of navigation more explicitly, a script-based button may become viable. But for now, it’s a platform limitation.

⸻

Let me know if you want help crafting a better layout workaround or submitting a feature request to the developer!

⸻

👋 This GPT is built specifically to help with Tap Forms questions. You can find it here: Tap Forms 5 Assistant.

[Hans]

Wow, thank you so much for the prompt response. I’m very impressed with how quickly it went. Unfortunately, I’m currently traveling for work and won’t have time until the weekend. When I have completed the implementation of the script in Tap Forms, I will get back to you with the result. Thanks again.

[Daniel Leu]

That’s an interesting project….

Following function should return the next track number you’re looking for. To keep the function generic, it returns an integer. You need to set the ids of the three different fields (date_id, track_number_id and track_id_id).

function getNextTrackNumber(){
	const date_id = 'fld-xxx';
	const track_number_id = 'fld-xxx';
	const track_id_id = 'fld-xxx';

	// get date and month from current record
	const date = new Date(record.getFieldValue(date_id));
	const month = date.getMonth()+1;
	const year = date.getFullYear();
	
	// filter records to match year/month of current record
	let recs = form.getRecords();
	
	let trackNumbers = [0]; // initialize array 
	recs.forEach((el) => {
		const thisDate = new Date(el.getFieldValue(date_id));
		const thisMonth = thisDate.getMonth()+1;
		const thisYear = thisDate.getFullYear();
	
		if (month == thisMonth && year == thisYear){
			let trackNumber = parseInt(el.getFieldValue(track_number_id));
			if (!isNaN(trackNumber))
				trackNumbers.push(trackNumber);
		}
	})
	
	console.log(JSON.stringify(trackNumbers, "",4))
	
	// get max value
	const maxTrackNumber = Math.max(...trackNumbers);
	const nextTrackNumber = maxTrackNumber + 1;
	console.log("nextTrackNumber: " + nextTrackNumber);

	return nextTrackNumber;
}

Attached is my test form. It contains two scripts, one to set the track number field and the other for the track id field.

The track number is automatically set to “01” when no entry is available, otherwise to the next value. You can overwrite this. The track id is set based on the date and the track number. Whenever you update one or the other, it’s updated as well.

Happy biking and tracking :-)

Attachments:

You must be logged in to view attached files.

Cheers, Daniel

---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks

[JScottA]

Hi Brendan,

Thanks for the clarification on Tap Forms 5 and the upcoming Pro version—very helpful!

To clarify, MCP (Model Context Protocol) is a protocol developed by Anthropic to facilitate integration between generative AI services (such as Anthropic’s Claude chatbot or ChatGPT) and external data sources or tools—like databases for analysis, or computational engines such as Wolfram Alpha for mathematical processing.

For example, imagine that I have an extensive database on my mountain biking adventures. Yes, I’m aware you are a mountain biker! My database has a lot of details on things like locations, routes, equipment used, points of interest, notable events, maintenance, etc. Using MCP, I could easily connect an MCP supporting chatbot (currently Claude and soon to be ChatGPT, Gemini, and many others) and have discussions with the data. For example, I could ask the chatbot to generate an outline for a book based on my biking adventures outside of Canada. The chatbot would use my TF5 database to access all of the data related to my natural language query and output what I asked for and in the format that I requested it, in this case a story outline.

A business owner could collect all of the customer reviews and comments and use a chatbot to generate a sentiment analysis from the database.

Eventually (provided Apple gets actually gets a vision) I could use information a TF5 database combined with Shortcuts/AppleScript to power automation locally like Zapier can currently do over the internet. By the way, Zapier has created 7,000+ MCP connections for powering automations with generative AI. Game changing for the automation business.

That’s great for Zapier, but I’m looking for a more local solution and a local database that I can build an MCP server to use for my Chatbot to access would be very useful to me and maybe to my clients.

I know that you are trying to get a new version out the door. So rather than work through getting an MCP server up and running for TF5, I should wait for the next one. If you are able to share information on data syncing or even API access to the new database, that might be helpful.