Latest Contributions by EddyClark

Hello Experts- I'm trying to create a web form that prevents users from entering a duplicate value.  The data is actually coming from a different database.  While using a pulldata calc to check if the value already exists, a few seconds after loading the field performing the query resets, and returns the first value in the table. Screenshot form initial load showing exactly what I want.  If the input value matches the pulldata calc, then show the red text and prevent the submission. However, after a few seconds, the pulldata calc refreshes? and then returns the first value in the table (null).  I'm certain it's the first value because I've renamed the value from null to something else. I've tried changing the service layer URL from the original to a view, tried putting the pulldata calc in "once(...)", tried different field types.  I'm baffled.     ... View more

I'd like to upload/create a report template before data arrives.     ... View more

Mainly I'm trying to see if there are fields that could set me up for success in the future.  For example, I use the edit mode on forms a lot.  So I have a "last_edit_user" field that pulls from username.  That way if I edit the data I'll still know who it was before me. Edit: I also just learned of the "mode" property that I could store in the data, so I know if the data is new or been edited. ... View more

Looking for a way to hide certain repeat rows while using mode=edit.   I have my parent table and repeat table.  If the value in the repeat meets a certain criteria, then show it.  If not, then don't show it.  For example I have my parent table (project site) and repeat table (plant observations).  If the plant status = 'endangered', then I want them (and only them) to show in the web form. ... View more