How can I create/format a contact info directory based on the data from a spreadsheet?
For example, instead of having Name, Address, Phone, Email as a table I need the following format:
Name and Phone (in one line)
Address and Email (on the following line)
MacBook Pro (13-inch Mid 2012), iOS 9.0.2
If by "report" you mean a listing that you can quickly generate to save or print out, you could do the following to create a TextEdit document like this:
... from a table like this:
SG
set {namCol, strCol, cityCol, stCol, codeCol, telCol, emailCol} to {"A", "B", "C", "D", "E", "F", "G"}
tell application "Numbers"
tell front document to tell active sheet
tell (first table whose selection range's class is range)
set theRpt to ""
repeat with i from header row count + 1 to row count
if column namCol's cell i's value is not missing value then
set theRpt to theRpt & ¬
column namCol's cell i's value & " " & ¬
column telCol's cell i's value & return & ¬
column strCol's cell i's value & ", " & ¬
column cityCol's cell i's value & " " & ¬
column codeCol's cell i's value & " " & ¬
columnemailCol'scelli'svalue & return & return
end if
end repeat
end tell
end tell
end tell
tell application "TextEdit"
activate
set newDoc to makenewdocument
set newDoc'stext to theRpt
end tell
If by "report" you mean a listing that you can quickly generate to save or print out, you could do the following to create a TextEdit document like this:
... from a table like this:
SG
set {namCol, strCol, cityCol, stCol, codeCol, telCol, emailCol} to {"A", "B", "C", "D", "E", "F", "G"}
tell application "Numbers"
tell front document to tell active sheet
tell (first table whose selection range's class is range)
set theRpt to ""
repeat with i from header row count + 1 to row count
if column namCol's cell i's value is not missing value then
set theRpt to theRpt & ¬
column namCol's cell i's value & " " & ¬
column telCol's cell i's value & return & ¬
column strCol's cell i's value & ", " & ¬
column cityCol's cell i's value & " " & ¬
column codeCol's cell i's value & " " & ¬
columnemailCol'scelli'svalue & return & return
end if
end repeat
end tell
end tell
end tell
tell application "TextEdit"
activate
set newDoc to makenewdocument
set newDoc'stext to theRpt
end tell
You can do something like this:
select cell E2 then double click the cell, then type (or copy and paste from here) the formula:
=A2&" "&C2&" "&B2&" "&D2
shorthand is:
E2=A2&" "&C2&" "&B2&" "&D2
If you are typing, please note....
There is a special character between the double quotes that appear empty..
C2&""&B2
when you type this, type it like this:
=A2&" "&C2&"
now hold the option key and type the return key (this enters a new line in the cell)
now finish typing:
"&B2&" "&D2
when entered in the cell it should appear like this:
now you can fill down by selecting cell E2 (just single click this time), copy
now select cells E2 thru the end of column E, paste
Hi VivianeR,
If you mean a "report" as data for a single person, try this as a way to pull details for a name from Table 1 into another table (Report)
In the Report table:
Type a name into Cell A1
Formula in A2 (address)
=INDEX(Table 1::B,MATCH(A1,Table 1::A,0))
Formula in B1 (phone)
=INDEX(Table 1::C,MATCH(A1,Table 1::A,0))
Formula in B2 (email)
=INDEX(Table 1::D,MATCH(A1,Table 1::A,0))
Regards,
Ian.
Generating a report from data on a Numbers spreadsheet.
