Jump to content
  • 0

Error Removing Column from Table


FredFarfadoe
 Share

Question

I am trying to remove unused columns from a large table in my application. I am able to delete the column, but on clicking "save", I get the following error message, and the column reappears:

image.png.0143e1c4d70e2c114ccbd70c8ca8be80.png

The field in question is not used in any relationship, datapage, view, task, or triggered action. All records have this field blank.

Does anyone have any insight as to what I'm missing? Thanks.

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Have you tried checking if there are any formula fields that are using the field? Also just to be sure that all records does not contain a value for this field you can try filtering in the Data Sheet as shown in this screenshot:

image.thumb.png.08053d7cf77a88194e62b13939680fa7.png

I hope it helps.

Link to comment
Share on other sites

  • 0

UPDATE: I have followed all above suggestions for this table. I went so far as to make a copy of the table, detach it entirely from the application, remove all triggered actions, delete every record, and it still gives me the same error message I posted on 8/23/21.

I did notice something unusual: although the table has no relationships, it still has the blue icon next to it signifying relationships (see image).

image.png.2cda6361c406704e2ecfd306b424566e.png

 

Does anyone have any insight as to what the issue could be?

 


 

Link to comment
Share on other sites

  • 0

The blue icon is actually not to signify an existing table relationship. This just means that the table is used by other apps. You can actually see in the screenshot that it is being used by multiple apps. Hence, the blue icon.

This might be a hassle to check but an idea that I have is to check all the apps listed on the screenshot (those blue texts can be clicked), click the properties of the table once more and see if there are any datapages, authentications, tasks, etc. in those apps that is using the table. As long as that icon exists, there must be an object that is using the table in another application.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...