Jump to content

Export calculated field's formula, not value..


spim

This topic is 4801 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi all,

It's my first time in here, and I used FMP for the 1st time 5 days ago... :)

I am gonna try not to waste your time and go straight to the point. Let's say I have this table :

fmpTbl.jpg

I want to export in any format that can be parsed (text/csv/xml...) something like this :

<?xml version="1.0" encoding="UTF-8"?>

<fields>

<field>

<name>FirstN</name>

<type>Text</type>

<options></options>

</field>

<field>

<name>LastN</name>

<type>Text</type>

<options></options>

</field>

<field>

<name>BDay</name>

<type>Number</type>

<options></options>

</field>

<field>

<name>BMonth</name>

<type>Number</type>

<options></options>

</field>

<field>

<name>BYear</name>

<type>Number</type>

<options></options>

</field>

<field>

<name>FullName</name>

<type>Calculation</type>

<options>FirstN & " " & LastN</options>

</field>

<field>

<name>BDate</name>

<type>Calculation</type>

<options>BDay & "/" & BMonth & "/" & BYear</options>

</field>

</fields>

Only the 2 last calculated fields really interest me, but I don't mind having more. Again, output can be any text format that can be parsed. Only showed XML because it appeared as a style in the fmforums box and I was curious to see how it would be formatted :)

In case you wonder why I don't just do it manually, I have just been given a huge, 450 fields in a single table FMP file to convert to MySQL... :) !!!

Thank you for taking the time to read! Thank you even more for taking the time to answer!!! :)

Spim!

Link to comment
Share on other sites

  • Newbies

Hi there,

After a whole morning wasted, hundreds of copy-paste, thousands of clicks and a few macro to automate what could be automated, I did get everything I needed manually! :angry:

Thanks for your answer! :)

Spim

Link to comment
Share on other sites

This topic is 4801 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.