TapForms for Mac: adding text line automatically to a note field

[Rudy Zwartjens]

A a musician I have a database with tunes I play, one record for each tune. In each record there is a note field: [performances] containing dates and locations of places where I played the tune (see screenshot).
Imagine that at the last concert I played 50 tunes, at date june 4 2015 in Amsterdam. So in 50 records the next line of text in the [performances] field would be (Dutch notation) “4-6-15 Amsterdam”.
My question: is it possible to add this line to the 50 note fields [performances] in an automatic way.
To challenge Brendan a bit: I could do that in Bento by concatenation in a calculation field ([performances] + ”4-6-15 Amsterdam”) and changing the field type back to text. I know this is impossible in TapForms, but maybe I overlook another possibility.
In fact if this would be possible, I would import my Bento database into the brilliant TapForms and would never use Bento anymore, but now… 50 times (or more) copying a line of text, after every concert, hmm.
Apart from this, thank you Brendan for your extensive and fast support for everyone.

Thinking along would be very much appreciated!

Rudy Ephraim.

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi Rudy,

You could use the Fill up/down function to copy the values to all the other records in your form. You can do this on the multi-column list view on the Mac version. Edit one record’s note field so it’s just how you want it to be, then click on the cell in the multi-column list view, then drag the yellow handle down (or up) which tells Tap Forms to copy the value from the field into every cell as you drag.

That should do it.

Thanks,

Brendan

[Rudy Zwartjens]

Thank you Brendan, but it isn’t what I meant.
Sure I am glad with this new Fill up/down function (YES!), but I didn’t mean to fill many fields with the content of one.
In my db the content of field [Performances] is different for each record (one tune I played in Haarlem, another in Amsterdam etc.) and now I want to add one extra line of text to all of them!
Hope I can make me clear in this way.

Rudy

[Leo]

Sorry, but this one is in Dutch:

Rudy,

het lijkt mij dat je een notefield gebruikt als open database.

Volgens mij kan je de verschillende gigs en gespeelde nummers beter kwijt in een “normale” database met aparte velden. Met de custos layout kan je deze dan op welke manier dan ook op A4 laten zetten met de veldnamen in brackets.

Of…
je maakt een hoofd database met de gigs, een database met de verschillende nummers en een link in de hoofddatabase (many to many met reverse visibility) naar de database met de verschillende nummers. Op die manier kan je bij de nummers ook zien waar je deze gespeeld hebt.

Als je wil kan ik je wel helpen met een opzet.

grt, Leo

[Brendan]

Hi Rudy,

I’m not sure what Leo said there, but I’m sure it was helpful for you.

If you just want to add an extra line, using the fill down function would allow you to quickly carry over the value from the previous record for the one field to a new record. Then you could modify the one value in the new record to add your additional line. Sorry if I’m still misunderstanding what you want to do.

Thanks,

Brendan

[Rudy Zwartjens]

Brendan,

I am obviously not able to explain what is the problem, sorry.
Leo has given me a hint in Dutch that maybe can be used, but now he has to explain to me what he actually means. So, Leo: shall we email about the subject (zwartjens@hetnet.nl)? and Brendan: thanks anyway for helping. I’ll let you know if a new discovery pops up.

Rudy.

[Author]

Posts