Printing custom reports from iPad (and others)

Discussions for the HanDBase for iPad and it's conduits and desktop add-ons

Re: Printing custom reports from iPad (and others)

Postby ddhsoftwareadmin » Sun Mar 18, 2018 8:42 am

margyandtom1 wrote:Hi,
I don't see how to find the Concatenate or combine text external app. You said in this stream that it is built in and easy to use, but you did not say what name to enter in the "Application Name" field when creating a field for this in your database. Please help. I have been waiting since 2013 for this function to be available, and it appears it has been for a long long time, but I still cannot get to it. I have HanDBase on Apple IPad now also.


Hi,

Thanks for your question. The Combine text feature is built into the iPad version of HanDBase (as well as the iPhone version). Here's how to access it:

Lets say you have field 1 as First Name, and field 2 as Last Name.
Go to the DB properties for your database.
First, create a new field to house the combined text output. Create a new field (eg, field 3) called Full name and choose Text field as the type. make sure you give enough characters to support the combined name length.
Now create another field and set the type to External. Under External Field Type, choose Combine Text.
In the Field for Combined Text, choose the field you created for output (in this example field 3- Full Name).
Choose the behavior for when to update this value- this can vary depending on what you want, but if the fields you are combining are only manually edited, the option 'On Every Record Save' may make the most sense. If the fields are auto generated (eg, a date field or calculation), you probably will choose on every record edit).
Now in Select First FIeld select the first field to combine (in this example field 1- first name)
Choose the separator if any.
Now choose the second field.

If you only have two to combine, you can set the third to 'No field' so that it doesn't combine a third, otherwise, choose the 3rd field to combine.

That's it- now give it a try and see if it works!

If you need more than 3 fields, you'll have to create multiple ones and combine them together.

I hope this helps!
ddhsoftwareadmin
Site Admin
 
Posts: 363
Joined: Tue Dec 09, 2008 2:13 pm

Re: Printing custom reports from iPad (and others)

Postby Lawrie » Fri Apr 13, 2018 10:43 am

Hi, not sure if this is covered in this forum already but I’m looking for a tutorial or video on creating related tables and reporting on parent and children. I find the user guides quite difficult to follow because of the different platforms. Also, despite the fact that I am really pleased with HanDBase, as a sql/Access developer I am having trouble with getting my head round links/Linked/relationships.
Lawrie
 
Posts: 1
Joined: Fri Apr 13, 2018 5:34 am

Re: Printing custom reports from iPad (and others)

Postby ddhsoftwareadmin » Sun Apr 15, 2018 8:00 am

Hi there,

Thanks for writing. There isn't a whole lot of documentation and help in the way of the reporting feature unfortunately. The Desktop documentation has it, but it sounds like you've already looked through that. There is one tutorial on using the reports feature:

http://ddhsoftware.com/knowledgebase.html?read=362

But there are a bunch of tutorials on the Link/Linked and Relationship field types. Here are some links:

Link/Linked:
http://www.ddhsoftware.com/knowledgebase.html?read=86

Relationship:
http://www.ddhsoftware.com/knowledgebase.html?read=195
http://ddhsoftware.com/knowledgebase.html?read=214
http://ddhsoftware.com/knowledgebase.html?read=221

Both:
http://ddhsoftware.com/knowledgebase.html?read=259

Coming from a DB background, the best analogy I can provide is that a Link field is like a Primary Key, and Linked field is like a foreign key. The difference is that the logic of creating the primary key is done internally and unlike a normal database manager where a single engine generates records, since there are multiple sources creating records in a mobile device scenario (eg, each iPad or iPhone), a simple auto-increment field can't really be used (multiple sources would overlap these values). So the link uses a complex combination of date and time stamps, an auto increment counter, and a device ID to make each record key unique. The value itself is hidden from view since it's so long and not very useful to see.

The relationship field was designed for allowing primary and foreign keys that the user specifies (via other fields). So if you already have a primary key in the data itself (eg, customer ID, or phone number), you can use that as the primary key by pointing to it from a relationship. Unlike a traditional database, the relationships are defined as fields rather than separately in ERD diagrams.

Hope this helps!
ddhsoftwareadmin
Site Admin
 
Posts: 363
Joined: Tue Dec 09, 2008 2:13 pm

Previous

Return to HanDBase for iPad

Who is online

Users browsing this forum: No registered users and 1 guest

cron