How do I create a custom form?

If I understand it correctly…or at least how I do it…is that I have a custom action that clears the USC columns prior to the Link To Screen action, and/or I clear the USC columns in a custom action after first Adding the Row. You shouldn’t be adding a row prior to the Link to Screen action. Really, in most cases, you will be editing the same (most likely the first) row every time you use and submit the form.

One suggestion I have is to create your 50 USC columns, but in a separate table with only one row. It will just be a work table to temporarily hold data while filling out the form. That way you can keep it separate from your form response table. Display your tab or screen using that new work table, fill out the form, and have it submit to you existing form response table.

1 Like

Thank you @Jeff_Hager, I will follow your suggestions.

(truth is that I have much more than 50 columns, because at least 15 of them require multiselect… cf. your post on this topic, and the app that you built, that I am “dissecting”)

1 Like

Yep, this is what I usually do. Although sometimes I’ll leave the user specific columns intact, and use them to build a CSS table to present the row that’s just been created, and give the user an opportunity to review and/or edit it. So I’ll show the user the table, plus a button bar with “Edit” and “Go Back” options. If they choose Edit, then they get an edit form pre-populated with the User Specific values, and if they choose “Go Back”, only then I’ll clear the User Specific columns.

Yes, I do this a lot. :+1:

4 Likes

Using this method, if I am pointing to a Glide Table that is new, I do not have access to the global User data…How to make it accessible? For example, I want to do column for Name, Photo and so on…

Thanks

Are you wanting to:

  • Add a new row to your User Profiles table,
  • Update an existing row in your User Profiles table, or
  • Reference columns in your User Profiles table?

You can see here the differences. I setup two buttons pointing to the same Glide Table,

  1. one to show form when clicked
  2. one to show new screen when clicked

you can see that 1. will allow me access to User’s Information and 2. does not. What I want is ability to access User’s Information in 2.


“Button Show Form”


“Show Form can access User’s Data”


“Button Show New Screen”


Cannot find User’s data

You didn’t answer my question :slight_smile:

Oh yes. Reference columns in User Profiles table

Okay. So it depends on whether or not you’re using row owners. If you are, just add a component and you’ll find that you can use columns from your User Profiles as the source. Row owners will ensure that you’re selecting from the row that belongs to the currently signed in user.

If you’re not using row owners, then it’s a little trickier. Essentially you’d need to create a single relation between the current table and your User Profiles table (using a template containing the current users ID or email address), and then import whatever columns you need using lookups via that relation.

This might be a case where a custom form isn’t a good choice - I can’t say for sure.

1 Like

understand. thanks

What are you trying to do with the user data? Are you trying to display it on the screen or pass it through the custom form when you submit the form? What you are showing with the user columns in the native form is to pass the user profile data into the form sheet. In a custom form, that same information would still be there, but in an action, such as Add Row. If I understand correctly, you should still be able to do what you want, but you just need to look in a different place to get that user data written to the form sheet.

2 Likes

Thanks @Jeff_Hager . I think I understand what you mean in the add row. Will try it.

1 Like

Great, Darren! Thank you.

So I am using conditions, in the action editor, and checking for user-specific fields that are written into from a selector. However, is does not hide my button bar or disable the button if the fields are empty. Please help.

Can you show us some screenshots? Do you mean that if fields are empty in an Add Row action then your button should be hidden (as you said you’re checking in the action editor).

I believe there are 2 cases when a button will be hidden:

  • It does not satisfy your visibility conditions.
  • You use branches of conditions for your action and the relevant data satisfies none of those.
1 Like

image

Which button do you expect to not be visible here? You’re using a button bar, and your screenshot shows that you have multiple branches of condition, if one of them is satisfied then your button will still be clickable.

So I thought that the next button would be disabled if the condition wasn’t met.

I am using an AND in my condition though.

But you also have a branch on the left of that, right? I assume that one is satisfied?