Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Importing from Excel


Recommended Posts

I have one col on an import that if blank needs to say "Member" in the FM record. The field contents from the Excel file can always be changing. The one constant will be if blank, the FM field should read "Member"


I have tried auto enter data, but the import overwrites. I see IsEmpty is not for text.


Need a clue here, please.



Link to comment
Share on other sites

A few questions to clarify...


Are you importing records that have a matching set so in other words are there 2 columns that you are importing? The record ID and than this "imported field". Or are you just overwriting/importing new records continually....


Dependant on the answers to the above...I think the answer is


You could set up an extra field... So in essence you have the field you import to and a calculation field that calculates something like this...




IsEmpty(ImportedField); "Member";






You have to make sure you have unchecked "do not evaluate if all referenced fields are empty".


Does this help?

Link to comment
Share on other sites

Thanks, I was trying not to create another field. I should have said this was part of a script, might have made the matter easier to understand. I did a replace field contents based upon calculation.


Testing worked well, we'll see how full production performs.



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use