Byggfakta SMART – Form and Fields in Microsoft Dynamics 365

Last updated on: 18-10-2023

To make changes to forms and fields, you need to be logged in to Make.powerapps.com.

When you are inside Dynamics, we recommend the following approach for adjustments to forms and fields.

Edit Your App

  1. Click on “Apps”.

  2. Click on “All”.

  3. Find the app you’re using; in this example, we’re using Sales Hub.

  4. Click on the ellipsis for Sales Hub.

  5. Click on “Edit”.

Add Settings Panel

After clicking “Edit” you’ll arrive at the following page, where you should:

  1. Click “New”.

  2. Click on “Web Resource”.

  3. Click “Next”.

After clicking “Next” you’ll reach the following page, where you should:

  1. Find and click on “Settings” in the URL. Make sure it is from “siteshop_smart_project_admin,” which you can verify by hovering your mouse over “Settings” and waiting for the description to appear.

  2. Next, you should name this tab. We recommend calling it “Byggfakta SMART Settings” You can name it just below the URL field, where our dropdown list in the picture might overshadow this field.

  3. Finish by clicking “Add”.

  4. Optional step: Limit this page to only be available to certain users, if needed.

Add project table to navigation

  1. Click “Add a new page”.

  2. Select “Dataverse table”.

  3. Click “Next”.

Afterward, you’ll reach this window where you should:

  1. Select an existing table.

  2. Search for “Smart”.

  3. Check the box next to “SMART Project”.

  4. Check the box next to “Show in navigation”.

  5. Click “Add”.

Now that you’ve created the SMART Project tab, you can choose its placement within the CRM system by moving it up or down.

  1. Click on the ellipsis.

  2. Choose where the menu should appear by using “Move up” or “Move down”.

Customize the form

  1. Click on “SMART projects form”.

  2. Click on “Edit Form”.

You will now arrive at the following window, where you should do the following:

  1. Click on “Component”.

  2. Click on or drag and drop “1-column tab” into the menu in step 3.

  3. It will now appear in the menu highlighted in step 3, and you can adjust its placement by dragging and dropping.

A new tab has been created, in this case named “New Tab” Now, follow these steps:

  1. Click on “New Tab”.

  2. Search for “HTML web resource”.

  3. & 4. Click on or drag and drop it into the “New Section”.

Now, the following window will appear, where you should:

  1. Search for “Smart”.

  2. Check “Project Members”.

  3. Click “Add”.

After the new HTML web resource has been created, follow these steps:

  1. Click on “Project Members”.

  2. Click on “Properties”.

  3. Compare the “Display options” to ensure they are the same.

Insert form fields

 Important: You must have the “siteshop_smart_project_id” field placed.

  1. Click on “Form field”.

  2. Click on “General”.

  3. Click on or drag and drop an element from the list that should be displayed in the Byggfakta SMART integration, and position it by dragging and dropping.

Fields

Field NameColumn nameDataTypeNote
Apartmentssiteshop_smart_apartmentsNumber
Assigned Tender Rolessiteshop_smart_assigned_tender_rolesText:199
Buildingssiteshop_smart_buildingsNumber
Categories Idssiteshop_smart_categories_idsText:39
Categoriessiteshop_smart_categories_namesText:199
Categories Numsiteshop_smart_categories_numNumber
Category Idsiteshop_smart_category_idText:39
Categorysiteshop_smart_category_nameText:39Configurable in admin (Default off)
Citysiteshop_smart_cityText:39
Client Statusessiteshop_smart_client_statusesText:39
Construction Areasiteshop_smart_construction_areaNumber
Contract Type Idsiteshop_smart_contract_type_idText:39
Contract Typesiteshop_smart_contract_type_nameText:39Configurable in admin (Default off)
Country Idsiteshop_smart_country_idText:39
Countrysiteshop_smart_country_nameText:39
Craftssiteshop_smart_craftsText:39
Decontamination Areasiteshop_smart_decontamination_areaNumber
Delivered Atsiteshop_smart_delivered_atDate
Demolition Areasiteshop_smart_demolition_areaNumber
Descriptionsiteshop_smart_descriptionText:199Configurable in admin (Default Description)
Detailed Stage Idsiteshop_smart_detailed_stage_idText:39
Detailed Stagesiteshop_smart_detailed_stage_nameText:39Configurable in admin (Default off)
Dev Type Idsiteshop_smart_dev_type_idText:39
Dev Typesiteshop_smart_dev_type_nameText:39Configurable in admin (Default off)
District Idsiteshop_smart_district_idText:39
Districtsiteshop_smart_district_nameText:39
Ecocertified Type Idsiteshop_smart_ecocertified_type_idText:39
Ecocertified Typesiteshop_smart_ecocertified_type_nameText:39Configurable in admin (Default off)
Expected Tender Rolessiteshop_smart_expected_tender_rolesText:39
Finish Datesiteshop_smart_finish_dateDate
Original Finish Datesiteshop_smart_original_finish_dateDate(Insert only on original creation)
Finish Date Accuracy Idsiteshop_smart_finish_date_accuracy_idText:39
Finish Textsiteshop_smart_finish_textText:199
Floorssiteshop_smart_floorsNumber
Framework Agreementsiteshop_smart_framework_agreementText:39
Geo Accuracy Idsiteshop_smart_geo_accuracy_idText:39
Gross Areasiteshop_smart_gross_areaNumber
Gross Volumesiteshop_smart_gross_volumeNumber
Project Idsiteshop_smart_project_idText:39Configurable in admin (Default on)
Location Latsiteshop_smart_location_latText:39
Location Lonsiteshop_smart_location_lonText:39
Materials Idssiteshop_smart_materials_idsText:39
Materialssiteshop_smart_materials_namesText:199
Materials Numsiteshop_smart_materials_numNumber
Modified Atsiteshop_smart_modified_atDate
Monthssiteshop_smart_monthsText:39
Postcodesiteshop_smart_postcodeNumber
Postcodesiteshop_smart_postcode_textText:39
Project Namesiteshop_smart_project_nameText:39Configurable in admin (Project name vs. title (Default Project name)))
Property Designationsiteshop_smart_property_designationText:39
Publish Source Idsiteshop_smart_publish_source_idText:39
Publish Sourcesiteshop_smart_publish_source_nameText:39
Region Idsiteshop_smart_region_idText:39
Regionsiteshop_smart_region_nameText:39
Renovation Areasiteshop_smart_renovation_areaNumber
Residence Formssiteshop_smart_residence_formsText:39
Roles Idssiteshop_smart_roles_idsText:39
Rolessiteshop_smart_roles_namesText:199
Roles Numsiteshop_smart_roles_numNumber
Source Idsiteshop_smart_source_idText:39
Stage Idsiteshop_smart_stage_idText:39
Stagesiteshop_smart_stage_nameText:39
Start Datesiteshop_smart_start_dateDate
Original Start Datesiteshop_smart_original_start_dateDate(Insert only on original creation)
Start Date Accuracy Idsiteshop_smart_start_date_accuracy_idText:39
Start Textsiteshop_smart_start_textText:199
Streetsiteshop_smart_streetText:39
Street Numbersiteshop_smart_street_numberNumber
Titlesiteshop_smart_titleText:39Configurable in admin (Project name vs. title (Default Project name)))
Uncertainty Idsiteshop_smart_uncertainty_idText:39
Uncertaintysiteshop_smart_uncertainty_nameText:39
Underground Floorssiteshop_smart_underground_floorsNumber
Update Endedsiteshop_smart_update_endedDate
Updated Atsiteshop_smart_updated_atDate
Usage Areasiteshop_smart_usage_areaNumber
User Emailsiteshop_smart_user_emailText:199
User Idsiteshop_smart_user_idText:39
User Namesiteshop_smart_user_nameText:199Possibly mapped in the admin
User Phonesiteshop_smart_user_phoneText:39
User Project Status Idsiteshop_smart_user_project_status_idText:39
User Project Statussiteshop_smart_user_project_status_nameText:39
Valuesiteshop_smart_valueNumber
Value Range Gtesiteshop_smart_value_range_gteText:39
Value Range Ltesiteshop_smart_value_range_lteText:39
Value Textsiteshop_smart_value_textText:39
Versionsiteshop_smart_versionText:39
What Happenssiteshop_smart_what_happensText:39
Smart Urlsiteshop_smart_smart_urlText:199Calculated by us. Options in admin panel
siteshop_smart_project_custom_1Going to be used in future versions
siteshop_smart_project_custom_2Going to be used in future versions
siteshop_smart_project_custom_3Going to be used in future versions
siteshop_smart_project_custom_4Going to be used in future versions
siteshop_smart_project_custom_5Going to be used in future versions
Disable AutoUpdatessiteshop_smart_disable_autoupdateCheckbox

Field NameColumn nameDataTypeNote
Company IDsiteshop_smart_company_idText:39
Versionsiteshop_smart_versionText:39
Namesiteshop_smart_nameText:199
Org NRsiteshop_smart_org_nrText:39
Par IDsiteshop_smart_par_idText:39
Cfar IDsiteshop_smart_cfar_idText:39
Cfar NRsiteshop_smart_cfar_nrText:39
Company NRsiteshop_smart_company_nrText:39
Company Typesiteshop_smart_company_type_nameText:39
Countrysiteshop_smart_country_nameText:39
Regionsiteshop_smart_region_nameText:39
Districtsiteshop_smart_district_nameText:39
Citysiteshop_smart_cityText:39
Postcodesiteshop_smart_postcode_textText:39
Location LATsiteshop_smart_location_latText:39
Location LONsiteshop_smart_location_lonText:39
Active Contactssiteshop_smart_active_contactsNumberA count
Source IDsiteshop_smart_source_idText:39
Updated atsiteshop_smart_updated_atDate
Phonesiteshop_smart_PhoneText:39Extracted from Communications
Mobilesiteshop_smart_MobileText:39Extracted from Communications
Faxsiteshop_smart_FaxText:39Extracted from Communications
Emailsiteshop_smart_EmailText:199Extracted from Communications
Websitesiteshop_smart_WebsiteText:199Extracted from Communications
Skypesiteshop_smart_SkypeText:39Extracted from Communications
Client Company Foldersiteshop_smart_client_company_folder_nameText:39
Delivered atsiteshop_smart_delivered_atDate
Modified atsiteshop_smart_modified_atDate
siteshop_smart_company_custom_1Going to be used in future versions
siteshop_smart_company_custom_2Going to be used in future versions
siteshop_smart_company_custom_3Going to be used in future versions
siteshop_smart_company_custom_4Going to be used in future versions
siteshop_smart_company_custom_5Going to be used in future versions
Postal Address Addresssiteshop_smart_postal_address_1_addressText:39
Postal Address Citysiteshop_smart_postal_address_1_cityText:39
Postal Address Countrysiteshop_smart_postal_address_1_countryText:39
Postal Address Districtsiteshop_smart_postal_address_1_districtText:39
Postal Address Mainsiteshop_smart_postal_address_1_mainText:39
Postal Address Postcodesiteshop_smart_postal_address_1_postcode_textText:39
Postal Address Regionsiteshop_smart_postal_address_1_regionText:39
Postal Address Streetsiteshop_smart_postal_address_1_streetText:39
Postal Address Street Numbersiteshop_smart_postal_address_1_street_numberNumber
Visit Address Addresssiteshop_smart_visit_address_1_addressText:39
Visit Address Citysiteshop_smart_visit_address_1_cityText:39
Visit Address Countrysiteshop_smart_visit_address_1_countryText:39
Visit Address Districtsiteshop_smart_visit_address_1_districtText:39
Visit Address Mainsiteshop_smart_visit_address_1_mainText:39
Visit Address Postcodesiteshop_smart_visit_address_1_postcode_textText:39
Visit Address Regionsiteshop_smart_visit_address_1_regionText:39
Visit Address Streetsiteshop_smart_visit_address_1_streetText:39
Visit Address Street Numbersiteshop_smart_visit_address_1_street_numberNumber

Field NameColumn nameDataTypeNote
Contact IDsiteshop_smart_contact_idText:39
Versionsiteshop_smart_versionText:39
First Namesiteshop_smart_first_nameText:39
Last Namesiteshop_smart_last_nameText:39
Source IDsiteshop_smart_source_idText:39
Updated atsiteshop_smart_updated_atDate
Phonesiteshop_smart_PhoneText:39
Mobilesiteshop_smart_MobileText:39
Faxsiteshop_smart_FaxText:39
Emailsiteshop_smart_EmailText:199
Websitesiteshop_smart_WebsiteText:199
Skypesiteshop_smart_SkypeText:39
Client Company Folder Namesiteshop_smart_client_company_folder_nameText:39
Delivered atsiteshop_smart_delivered_atDate
Modified atsiteshop_smart_modified_atDate
siteshop_smart_person_custom_1Going to be used in future versions
siteshop_smart_person_custom_2Going to be used in future versions
siteshop_smart_person_custom_3Going to be used in future versions
siteshop_smart_person_custom_4Going to be used in future versions
siteshop_smart_person_custom_5Going to be used in future versions