Iโm creating an application which helps โgate guardsโ register in visitors who are being escorted. There is a one key feature that I havenโt been able to easily figure out. I have a spreadsheet listing of people who are on a โDo Not Enterโ listing. What I would like to see happen is that when someone is entered into the app who is on the โDo Not Enterโ list there name would format red and with a flag. I know how to do the formatting. I just donโt know how to have Appsheet look at the โDo Not Enterโ spreadsheet to make that connection. Anyone have any ideas?
@Emergency_Manager The recipe I provided should give you what you want. Specifically:
โIn If this condition is true, enter the following formula: =IN([Visitor Name], Do Not Enter[Name]) (replace Visitor Name with the name of the appropriate column in the table identified in the previous step).โ
The idea is you want that list of โDo Not Enterโ names in another table that you can reference in expressions, then checking against it is easy.
@Sdfaheemuddin I was able to previously add the data as a table. What Iโm trying to do is have my โEscort Dataโ which is entered by the gate guard on the app and populates a different google sheet, I would like once the person is entered and you can see their name and picture in the mobile app, I want Appsheet to then look at the second source of data, a โDo Not Escortโ List. If the person that they entered is on that โDo Not Enterโ list I want the App to format that persons name with a flag and to go red. I know how to format data so that isnโt the trick. I just canโt figure out how to get appsheet to use a second source of data to specifically QC the data and pin point discrepancies.
โQCโ?
If you want to apply different formats to different columns, or under different conditions, youโll need additional rules. Each rule must have a unique name.
QC in this case means Quality Control. Iโve been able to do formatting in other apps I have created, my challenge here isnโt necessarily the format scripting.
What I have is a static list of people I do not want to enter an area. Gate guards will be using the app to register in guests and their escorts into an area. What I would like the app to do is as they register a new person into the area, if that persons name matches a name on the โDo Not Enterโ list then that new data, that was just entered, will format accordingly, for example larger font, bold red, and a large red flag next to the name. This will prompt the gate guard to further review the list to bounce it against DL# etc.
Assuming your spreadsheet of โDo Not Enterโ names is available in your app as a table called Do Not Enter, and that the column in it with the names is Nameโฆ
In the app editor, go to UX > Format Rules and click Add New Format Rule.
Set Rule name as desired.
In For this data, select the table that contains the column (or columns) you want to highlight in the app. This would be the table corresponding to the form the guards fill out when someone enters the facility.
In If this condition is true, enter the following formula: =IN([Visitor Name], Do Not Enter[Name]) (replace Visitor Name with the name of the appropriate column in the table identified in the previous step).
In Format these columns or actions, select one or more columns to be highlighted when a match is found on the โDo Not Enterโ list.
In Icon, optionally choose an icon to be displayed immediately next to the columns chosen above when the visitorโs name matches. You can only choose one icon.
For Highlight color, optionally choose the color for the icon you chose, if any.
For Text color, optionally choose a color for the column text when the visitorโs name matches.
For Text size, optionally choose a text size adjustment. 1 means โno changeโ.
For Text style, optionally enable additional font effects to apply when the name matches.
The WORKFLOW TEMPLATES section doesnโt apply in your case.
Provide a Descriptive comment as you see fit.
SAVE your changes.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |