Search Results for 'script'

[Josef Tingbratt]

Hi!
I have used chatGPT to create a script in a field that creates a nice Markdown filed of parts of my data. It makes it easy to save datain our devops from my meeting-notes and I can still keep track of my records.

However it only works when I open up the script in edit script and clicks “save”. So I have to that when I cwant to create a markdown. Is it possible to make the script run when a post is saved?

I have tried ChatGPT here, but it only talks about functions and buttons I can’t find I tap Forms.

[tonyt]

Hi Brendan
How will the subscription work? Per year, per major point upgrade, every other major point upgrade as some other apps do, or something else?
Cant wait!
Best
Tony

[Shane]

Hello all,

I’m just starting to learn how to use scripts in TapForms 5. I do have some knowledge of Javascript from a web programming perspective.

I thought I’d start with something simple such as create a button that deletes a record. I created the button, and assigned the following script which gets the current record, and then attempts to delete it:

function delete_record() {

	// get current record
	var thisRecord = record.getId();
	// delete the record
	form.deleteRecord(thisRecord);
}

delete_record();

The console reports: “deleteRecord: TypeError: Argument does not match Objective-C Class, line:(null)”

I’m sure I’m doing something really noob here such as combining a record function with a form function.

Thanks in advance.

[Brendan]

It will be a subscription. With a period of time discount for existing customers.

If I continued with a pay once model like I have for the last 16 years, I will not be developing Tap Forms for much longer. And that would make you and I very unhappy. I’ve been working on this new version for the past 2 years. It will be much better as a subscription app because I’ll be able to release new features and fixes as I develop them rather than having to wait so long to bundle them up into a new upgrade. There’s nothing stopping you from continuing to use Tap Forms 5 though. It will still work for years to come. Even Tap Forms 3.5 still works on Sequoia and that hasn’t been updated since 2016.

As you know, Apple doesn’t support the paid upgrade model in the App Store, so it’s very difficult for developers to offer that kind of service. I managed it with the App Store bundle upgrade feature, but that also meant that I had to keep Tap Forms 3.5 around without updates since then. And Apple actually removed the iPhone and iPad versions of Tap Forms 4 from sale, so the iOS upgrade bundle is no longer available. I’ve just been waiting for them to remove the Mac version too.

As an indie app developer, I don’t have a huge bank account like medium to large companies do in order to continuously fund new development. I do this because I love it and am passionate about adding cool new things into Tap Forms and interacting with my customers, but I still need to be able to earn a living and pay my bills too.

I hope you understand my reasoning.

Thanks,

Brendan

[Shane]

Hi Brendan,

Will the new version be a paid upgrade or (hopefully not) a subscription?

• This reply was modified 10 months ago by Shane.

[Hans]

@Daniel / @Brendan : You made my day! Thanks! The script is running, and I already use the structure of the script for other use cases.

[Hans]

Thank you for your prompt feedback. Yes, the field was unfortunately empty, and now I get the values. It was for sure a beginner’s mistake.

Now I have the values:

{
    altitude = “yyy.xxxxxxxxxx”;
    heading = “z”;
    lat = “45.xxxxxx”;
    lon = “12.xxxxxx”;
    pitch = 0;
    title = “street, ZIP city region, country”;
}

Now I know that this is the output of a dictionary, which contains keys (e.g., “title”, “lon” …) and values (e.g., 45.xxxxxx).

Question: What do I have to do now to get the value from the key “title”, for example?

The suggestions here in the forum or on “stack overflow” have only produced errors within the script, and unfortunately, I don’t understand why – maybe because I am a beginner ;-).

If I get this solved, I have the form of “POIs” ready and can then develop all the other forms further, as I have similar queries here.

Many thanks in advance.

Best Regards, Hans

[Hans]

Dear forum participants.

Briefly about me, my question (problem) below.

For over 8 years, I have managed my data with a NINOX -DB. I have tested Tap Forms sporadically, but I would rather not try the scripts. Well, from today’s perspective, a mistake ;-)

Finally, I found my way to Tap Forms, and I am very enthusiastic because Tap Forms offers everything I had before, and it is even easier and much more stable than NINOX. And I also get along well with JavaScript so far.

My DB is used:

• POIs (Point of Interests) for hiking, biking, and photography
• Tracks and routes: Record tour data (places, countries), types (MTB, hiking), difficulty (S0, S1, …), duration of a tour, with breaks, etc., weather data, and much more.

To my question, for which I need your support:

Goal: I would like to place the content from two different fields in a third field:

1)) Source: “Name of the location”
2)) Source: “Address of the location”
3)) Target: (“Name of the location”, “Address of the location”)

However, with a simple console query, I only get the error message “undefined”.

Script:

function Addresse_mit_Name() {

	// field: address of the POI
	// 1st row: street, ZIP, city
	// 2nd row: lat & lon (GPS)
	//
	var adresse_des_poi = record.getFieldValue('fld-2a75296d19a64123ba33be5a6e5808ba');

	// check values of field
	console.log(adresse_des_poi);

	// return of combined values
	return(adresse_des_poi);
}

Addresse_mit_Name();

Question:

What do I have to do to get the address from the location field, which I can then process as a variable?

Source field:

1)) Address
Type “location”
Name: “Address of the POI”
field-ID: ‘fld-2a75296d19a64123ba33be5a6e5808ba’

Many thanks in advance for your support.

Best regards, Hans

[Brendan]

I’m not sure what you mean by “a way/ or script that can be made to download all to one document”. Do you mean you want to import into a different Tap Forms document?

It sounds to me like you’re building a website and want to display your images from Tap Forms on the web? Then you could just take the images exported and upload them all to your images folder on your website and then update the HTML to reference the images appropriately. Tap Forms will include the image name in the CSV file export that matches the export. If you want to make it easier for yourself, you could add a Calculation field which generates a path to the photos that’s appropriate to reference on your website. So it would just be a matter of importing that CSV file into your website and then uploading the images to the right folder.

Thanks,

Brendan

[CreativeGal]

Hello, I am looking for a way to be able to download some information from Tapforms to put into a spreadsheet for my Wix website portfolio/shop form. I have added a screenshot of what I am trying to achieve. (Image, SKU Number, Name). Currently when I export the information the images go into their own folder and I have to match each one of them up to their information. Is there a way / or scrip that can be made to download all to one document?

I’m not sure if it is a script that is needed or a different way to export. Any suggestions would be helpful.

Many Thanks

Attachments:

You must be logged in to view attached files.

[pierrot_rennes]

Hi Brendan,

Thanks for your help
I tried it, but it didn’t work.
I probably didn’t understand how to insert or modify the script.
Here’s a screenshot.
I assumed I had to insert the form name into the script.

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi Pierrot,

Yes, you would need a script to get the counts of the individual forms and searches.

I should make it easier to get those counts, but for now something like this should work:

function getCountsOfFormRecords() {
   let theForm = document.getFormNamed("The Form");
   let theFormRecords = theForm.getRecord();
   return theFormRecords.length;
}
getCountsOfFormRecords();

[pierrot_rennes]

Hi,

I have a database with 4,400 records spread across several subforms.
I would like to create a table-based form to count the totals of certain fields in the subform records.
Is it possible to retrieve the column count value, and how do I build the form? Is there a script?
Thank you for your help.

Attachments:

You must be logged in to view attached files.

[Daniel Leu]

1.) Is there a way to find the selected cell in a column from a table field? (image attached)

AFAIK, the select state of a cell or row is not exposed.

2.) Can I call a File open window to select a file on my hard drive to get a UNIX file path?

To open Finder, you can use Utils.openUrl("file:///Users/josef/Desktop");. For this to work, you need to set the script access folder.

To get the file path, control-click, middle mouse button, or two-finger click on the file to get the context menu, press the option key and select Copy “xxx” as Pathname.

Then you can write a script that gets the copied Pathname from the clipboard using Utils.copyTextFromClipboard() and proceed with processing it. To trigger the script, you can use a checkmark field like you launch the play in VLC script.

You can automate this further: Create an AppleScript that is selected from the Quick Actions context menu. This script would get the file path and then call a TapForms script using tapformz://script/db-xxxx/frm-xxxx/Test+Script?option1=A&option2=B. Most likely you would have to provide the id of the record and the id of the table row record as parameters. This script would then store the file path in your table.

Sounds like a fun project!

Cheers, Daniel

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

[Josef Senti]

Hello

1.) Is there a way to find the selected cell in a column from a table field? (image attached)
2.) Can I cal a File open window to select a file on my hard drive to get a UNIX file path?

I’d like to write a script that can write the path of a file in a selected table cell.
Or by input window, but ideally with a window that let me select the file on the hard drive.

For example:

Open file search window
Get the UNIX path of that file
Add “file://” in front of that path
Look for the selected cell in the column
Write the path in that cel

Attachments:

You must be logged in to view attached files.