Required columns when uploading a CSV file

[Mayura]

Hi All

I have a problem. I'm making an app that uploads part of the columns through a CSV file and the rest of the columns are updated by the user from the app after the CSV file is been uploaded. I need to keep the user updating columns as required as those columns are mandatory. But when I make the columns required it doesn't allow me to upload the CSV file since the CSV file does not contain those columns.

Is there a solution for this?

[WillowMobileSys]

Set a condition in the Required_If property to only be required for a certain view.  You would use the CONTEXT function for this.  An example expression would be:

CONTEXT("View") = "My View Name"

[Mayura]

Hey

Thanks for your reply. But it doesn't seems to work. Below is what I did.

I have a column called "Brand" that needs to be a mandatory field to fill by the app user and it should display in the view "T n A". Please let me know if I have done a mistake.

[WillowMobileSys]

Yo

---

@Mayura wrote:

Thanks for your reply. But it doesn't seems to work. Below is what I did.

---

Your original issue was that you could not upload a CSV file because certain columns were marked as Required and they were not populated in the CSV.  By placing the expression in the problem "Required" columns, you should have been able to load the CSV file successfully.  Were you able to?  If not, are you getting the same error?

[Mayura]

Hey

I can upload the file. But once I upload it I need the user to see the column has a required column. With the expression it doesn't show as a required column. I have added the expression in "Brand". Is my problem clear for you?

[AleksiAlkio · Accepted solution]

One way is to write a formula like CONTEXT("Host")<>"Server" to Required_If.

[Mayura]

Thanks a lot @AleksiAlkio and @WillowMobileSys.. 

[AleksiAlkio]

You're welcome!

[ejo_22]

Hello, I am trying to do a similar upload. However. I would like to give my user the option to manually fill out the form and make the columns required. I would also like to give them the option to upload a csv for a bulk upload. Is there a way to make the columns required and still able to upload a csv?

[AleksiAlkio]

If I understand your request, the above proposal I gave earlier should work as well. Though I'm not sure what do you mean by "and make the columns required."