Latest Contributions by oakmn

‎06-14-2021

Thank you for that tip. I have decided to create an UPDATE query in pgAdmin instead of creating a query table.

‎06-14-2021

Is there a way to assign which tab is selected when "Show Related Records" is chosen? I have two related tables, but the one that opens up by default isn't the one I want to open by default. I have attached a screenshot of what I am describing:

‎06-10-2021

I got it to work. This is what I did in pgAdmin: CREATE OR REPLACE VIEW v_flare_ends_global AS SELECT DISTINCT tbl_flare_ends.globalid, tbl_media_2.media_table, tbl_media_2.media_name, tbl_media_2.media_date_added, tbl_media_2.media_path, tbl_media_2.media_table_id FROM tbl_flare_ends JOIN tbl_media_2 ON tbl_flare_ends.originaloid = tbl_media_2.media_table_id_integer WHERE tbl_media_2.media_table::text = 'tbl_flare_ends'::text; ALTER TABLE v_flare_ends_global OWNER TO sde; GRANT ALL ON TABLE v_flare_ends_global TO sde;

‎06-10-2021

Vince, I am guessing a query table might be the best solution? Something like this? SELECT sde.sde.tbl_flare_ends.globalid FROM sde.sde.tbl_flare_ends INNER JOIN sde.sde.tbl_media2 ON sde.sde.tbl_flare_ends.originaloid = sde.sde.tbl_media2.media_table_id_integer WHERE media_table = 'tbl_flare_ends'

‎06-10-2021

Vince, Yes, I apologize. I should have stated I want to obtain Globalid's and copy them to another table as GUID's. Both are in a single Enterprise geodatabase. The table I am looking to populate the GUID field with the globalid's has 55,000 rows... I have tried creating a query table, but that failed. I have also tried utilizing joins, but when joining the GlobalID field doesn"t come along...

‎06-10-2021

In our old mapping system, all images and attachments were saved to a folder on our web server. The table was populated with the url. Would I be able to accomplish this workflow with Integromat and Survey123?

‎06-09-2021

I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?

‎06-09-2021

I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?

‎06-09-2021

Thanks Dan. When joining, it does not bring the globalid field with, so I am not able to calculate a new field with those values...

‎06-08-2021

Dan, Even if the stand-alone table / related table has multiple entries with the same objectid?

‎06-08-2021

I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?

‎05-13-2021

Why not just use Collector to move the current point, then click on a link you create to open the survey and then capture that data?

‎05-11-2021

@ZacharySutherby , It doesn't, but that is because I am dealing with a related table, and its ID is 1. In the form_id column, I have the related table name.

‎05-11-2021

I am having the same issue. I get: "The custom feature service submission url is not compatible with this survey (Parent layer id 0 not found for table 'table_name')"

‎05-10-2021

Thank you Ned!

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by oakmn

Re: Obtain Globalids From Another Table

Select Widget: Show Related Records, Default Tab Selection

Re: Obtain Globalids From Another Table

Re: Obtain Globalids From Another Table

Re: Obtain Globalids From Another Table

Integromat & Survey123: Write image/photos to a specific folder on a server?

Obtain Globalids From Another Table

Obtain Globalids From Another Table

Re: Obtain Globalid From Another Table

Re: Obtain Globalid From Another Table

Obtain Globalid From Another Table

Re: Survey widget- Use Current Location on Map to pre-populate Survey location.

Re: Publish Error

Re: Publish Error

Re: Passing URL Parameters to 'Near Me' Widget.

Re: Understanding Survey123 Feature Reports

Re: Add Attachments using URL

Re: How do you remove thousand comma separators on...

Append Field Mapping - Can you enter values to pop...

URL link from related table in popup?

Web AppBuilder Custom Widgets