Search the Community
Showing results for tags 'xlsx'.
Found 2 results
Little Mighty posted a topic in Importing & ExportingHi Guys I can't figure out a solution for this. The final result is an export, No data have to be stored in filemaker afterwards. I need to combine and export data from 3 tables to the SAME field in Excel. Lets say we have table A: A1, A2 and A3, table B: B1, B2 and B3 and table C: C1, C2 and C3. These are tied together by a unique number in the solution. I need these fields to output i the export as all 1's in one column beneath each other, all 2's in one column beneath each other and all 3's in one column beneath each other. I am thinking, that I need a new table to combine these fields in 3 new fields D1, D2 and D3 and then do the export of this table. After export, the table could be deleted until next export. I am thinking this should be set up as a script. Does the above make sense, and could it be done via a script? Thanks for the help - really appreciate it!
Ok probably like a lot of folks that post here, I'm a beginner... I am having some issues exporting to xlsx files in relation to my value lists. Basically, I have foreign keys going in to text-fields, using the pop up menu for translation. However, when I go to run exports, the pop-up menus don't override the foreign keys. At this point I'm sort of at a loss, as I've come up with very little on the Google machine, in regards to this type of situation. I've tried every way I can think of to change my relationship set ups, but the dynamic nature of the value list is the only option that seems to fit my scenario. Is there some type of script, calculation field or text w/calculation that I could run that would take care of this? The folks at my work live and breathe Excel, so this is sort of a project requirement. Any help is appreciated. Thanks, Ted