Hi @Meow_Glitter ,
Do you want to save the new Site Inspection entry back to your Excel table?
Within this Site Inspection template app, when you press the "Done", the new entered Site Inspection entry would be saved into the SiteInspectorcollect collection in default.
If you want to save the new Site Inspection entry back to your Excel table, you need to replace the SiteInspectorcollect collection with your own Excel table as data source within this template app.
You must make sure your Excel table contains the following columns:
Within the OnSelect property of the "Done" button, please replace all SiteInspectorcollect collection with your own Excel table.
If you replaced Text Input box with Dropdown box within this template app, when referencing entered value from these Dropdown boxes, please use the following formula:
Dropdown1.Selected.Value
Dropdown2.Selected.Value
Dropdown3.Selected.Value
...
...
So on your side, the OnSelect Property formula of the "Done" button should be like below:
If(
!IsBlank(TitleDropdown.Selected.Value) && !IsBlank(SubTitleDropdown.Selected.Value) && !IsBlank(AddressDropdown.Selected.Value) && !IsBlank(StateDropdown.Selected.Value) && !IsBlank(CityDopdown.Selected.Value) && !IsBlank(ZipText.Text) || !IsBlank(TitleDropdown.Selected.Value) && !IsBlank(SubTitleDropdown.Selected.Value) && Radio1.SelectedText.Value = "Use GPS for current Location",
Collect(
SiteInspectorcollect,
{
ID: Value(Max(SiteInspectorcollect,ID) + 1),
Title: TitleDropdown.Selected.Value,
SubTitle: SubTitleDropdown.Selected.Value,
Description: DescriptionText.Text,
Address: AddressDropdown.Selected.Value,
City: CityDopdown.Selected.Value,
State: StateDropdown.Selected.Value,
Zip: Value(ZipText.Text),
Notes: NotesText.Text,
Latitude: If(
Radio1.SelectedText.Value = "Use GPS for current Location",
Value(Location.Latitude),
""
),
Longitude: If(
Radio1.SelectedText.Value = "Use GPS for current Location",
Value(Location.Longitude),
""
),
IsGPSCoordinates: If(
Radio1.SelectedText.Value = "Use GPS for current Location",
true,
false
)
}
);
If(
Best regards,
Hi @Meow_Glitter ,
Do you want to save the new Site Inspection entry back to your Excel table?
Within this Site Inspection template app, when you press the "Done", the new entered Site Inspection entry would be saved into the SiteInspectorcollect collection in default.
If you want to save the new Site Inspection entry back to your Excel table, you need to replace the SiteInspectorcollect collection with your own Excel table as data source within this template app.
You must make sure your Excel table contains the following columns:
Within the OnSelect property of the "Done" button, please replace all SiteInspectorcollect collection with your own Excel table.
If you replaced Text Input box with Dropdown box within this template app, when referencing entered value from these Dropdown boxes, please use the following formula:
Dropdown1.Selected.Value
Dropdown2.Selected.Value
Dropdown3.Selected.Value
...
...
So on your side, the OnSelect Property formula of the "Done" button should be like below:
If(
!IsBlank(TitleDropdown.Selected.Value) && !IsBlank(SubTitleDropdown.Selected.Value) && !IsBlank(AddressDropdown.Selected.Value) && !IsBlank(StateDropdown.Selected.Value) && !IsBlank(CityDopdown.Selected.Value) && !IsBlank(ZipText.Text) || !IsBlank(TitleDropdown.Selected.Value) && !IsBlank(SubTitleDropdown.Selected.Value) && Radio1.SelectedText.Value = "Use GPS for current Location",
Collect(
SiteInspectorcollect,
{
ID: Value(Max(SiteInspectorcollect,ID) + 1),
Title: TitleDropdown.Selected.Value,
SubTitle: SubTitleDropdown.Selected.Value,
Description: DescriptionText.Text,
Address: AddressDropdown.Selected.Value,
City: CityDopdown.Selected.Value,
State: StateDropdown.Selected.Value,
Zip: Value(ZipText.Text),
Notes: NotesText.Text,
Latitude: If(
Radio1.SelectedText.Value = "Use GPS for current Location",
Value(Location.Latitude),
""
),
Longitude: If(
Radio1.SelectedText.Value = "Use GPS for current Location",
Value(Location.Longitude),
""
),
IsGPSCoordinates: If(
Radio1.SelectedText.Value = "Use GPS for current Location",
true,
false
)
}
);
If(
Best regards,